You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Recent content by Vishnu
-
V
[Solved] Excel Problem: Index Match ID and Closest Matching Date
Hi Yousuf, Unfortunately, it doesn't give the correct value. At least, it's not showing <N/A> everywhere.. I believe we should keep the exact match because for those values where we have the exact <CreatedDate> & <Yarn>, it actually gives the exact <Price>. I believe we are close, please hold...- Vishnu
- Post #5
- Forum: Excel Formulas
-
V
[Solved] Excel Problem: Index Match ID and Closest Matching Date
Hi Yousuf, Thanks for your support. (Never used this combination and I managed to understand the formula... Thanks to you.) However, this not working unless Table2 <CreatedDate> match EXACTLY to Table1 <CreatedDate>, which, here is not the case. The fact is that the date in Table1<CreatedDate>...- Vishnu
- Post #3
- Forum: Excel Formulas
-
V
[Solved] Excel Problem: Index Match ID and Closest Matching Date
Hi Exceldemy team, I thank you in advance that your website exist. I have attached an example of my problem that have been struggling for several days to solve. Just need to find the respective <Price> from another Table2, matching the YarnID AND the closest <Created Date> Please help- Vishnu
- Thread
- Replies: 5
- Forum: Excel Formulas