LinkBack URL
About LinkBacks
Dear,
Kindly help me in using the VLOOKUP in searching the values if the lookup value has more than one reference in table array. I want the result in acending order by date. I have attached the file.
Regards,
Jagadish
Result of VLOOKUP in by ascending order
Dear,
Kindly help me in using the VLOOKUP in searching the values if the lookup value has more than one reference in table array. I want the result in acending order by date. I have attached the file.
Regards,
Jagadish
Hi Jagadish,
In Receipt Recon sheet, You need Q194 as 490.. correct ?
Can you give a bigger example to cover date order as well ? thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Dear Dillip,
Yes, i need Q194 as 490. The attachment contains huge data. Kindly remove the filters. Hope you got it.
Thanks
Jagadish
What if there are more matches for 6773.. that's why I asked"Can you give a bigger example to cover date order as well ? thanks."
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks