I get the #ref! error when I use the Vlookup function as outlined in the previous post. I have attached an example of the data.
I get the #ref! error when I use the Vlookup function as outlined in the previous post. I have attached an example of the data.
I see the error, and I initially advised you incorrectly.
Your lookup range has to encompass all of the data you are looking in. You have:
=VLOOKUP(B2,Sheet2!$A$1:$A$2000,2,FALSE)
It should be
=VLOOKUP(B2,Sheet2!$A$1:$B$2000,2,FALSE)
Notice the lookup range has changed from A1:A1000 to A1:B1000
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks