Hi
I am trying to match values in three different spreadsheets in the same workbook. The formula that I have selected is =IFERROR(VLOOKUP(A2,PO!B:B1,0),"no").
Instead of returning the matching value, it is only returning the word no in every cell incorrectly. How can I modify the formula successfully so that the matching values are shown?
Thank you Excel super-users!
It will be difficult for us to tell you what is exactly wrong without having a sample workbook, but your range doesn't seem to be correct.
You either use PO!B:B or PO!B1:B100 (the range you are actually looking in, 100 is just an assumption). Besides that you probably want col index number 1 (if you want a column that is before the value you are actually looking up you are better of using Index Match)
Remember to mark as Solved and give out rep.
Tried adding the complete column range but with same result. I don't know Index matching unfortunately. I can't see how to post an example of the formula in a workbook on this thread.
You miss the comma, please try
=IFERROR(VLOOKUP(A2,PO!B:B,1,0),"no")
This worked - one comma made all the difference! Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks