Hello-
I just realized a VLOOK I have been using is not working like I thought it was. I have attached an example that shows how I am matching a name in Column A with a name in Column C, and then pasting the value in Column B into column D.
You'll see that it's not working for "John." It appears that if a name in Column C appears in a higher row number that its match does in Column A, it won't work. Is there a way to make this work regardless of what rows the names are in? Thanks!
hi there. you are very close. just have to fix the reference of A2:B5. you realize that changes when you copy it to the cell below. it becomes A3:B6. when it reaches D5, it is looking at A5:B8. A5:B8 has no "John" in it and hence it returns an NA. fix the row by using this formula in D2:
=VLOOKUP(C2,A$2:B$5,2,FALSE)
this is so that when you copy it downwards or upwards (to the row), the row reference wont change
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Ahh! Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks