Hi
In the file names tab, I'm trying to return the value in column AQ of the look up values tab. The file names are completely disorganised and occur in a number of columns / rows. The index match formula that I've attempted clearly isn't working. Does anyone have any advice?
Thanks!
Lauren
Last edited by Laurenclaire; 10-04-2019 at 08:44 AM.
it is because you don't have exact matches, for example this one (file names row 2) en-usX9192ca8dad444b6a95ba8b21c84e1efe_P220_Qloop_1.Q_FileUpload_Picture.jpg
is close to this one (look up values row 123) en-usX9192ca8dad444b6a95ba8b21c84e1efe_P220_Qloop_1.Q_FileUpload_Picture.jpg,|FolderSize:0 MB
except for the part at the end.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Please try
B2
=IFERROR(INDEX('Look up values'!$AQ:$AQ,AGGREGATE(14,6,(--('Look up values'!$A1:$AP500=$A2)*ROW('Look up values'!$A1:$A500)),1)),"")
ps. you may increase 500 to others number.
Regards.
Last edited by menem; 10-04-2019 at 09:17 PM.
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
Thank you both so much for your help... works perfectly now. Have a lovely weekend!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks