Search a value then return a certain value from the separate sheet
Hi! Thank You for your advance help.
Here is my problem. I have a sheet named formula the column highlighted in orange will be used in searching to the other sheet which is the table, I try to used the formula VLOOKUP but it didnt work. Please Help. Thanks!
You have posted this in the Access forum, but it seems to be an excel question. I will move it for you, PM me if i was mistaken
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
OK try this in A1, copied down and across...
=IFERROR(INDEX(TABLE!$A:$C,MATCH(Formula!$D3,TABLE!$D:$D,0),COLUMN(A$1)),"")
For VLOOKUP() to work, the column with the criteria in it, must be in the 1st column of the range, vlookup() cannot look "behind" itself
Try in A3:
=INDEX(TABLE!A$1:A$51,MATCH(Formula!$D3,TABLE!$D$1:$D$51,0))
drag across.
Quang PT
Thank for your help it works.
Thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks