Okay, I feel dimwitted right now. I have used vlookup in other spreadsheets I have put together with no problem but for some reason I am not getting it to work in this one.
I have attached a small test workbook that shows my problem.
I am trying to fill in a cell with whether a fish is bred or not. The data comes from a data table of all the fish breeds. I keep getting the #N/A error.
I know this is going to be something simple I am overlooking.
Thank you.
hi CWatsonJr. the 1st column of the table_array must be the column where the lookup_value can be found. so:
=VLOOKUP(A2,Sheet1!C:D,2,0)
or:
=VLOOKUP(A2,Sheet1!C:D,2,FALSE)
if the corresponding column is a blank, you can hide it by using:
=VLOOKUP(A2,Sheet1!C:D,2,0)&""
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
Your formula should besince you're looking in column C and returning D, you don't need to look at columns A & B
Please Login or Register to view this content.
If this helped, please click (*) Add Reputation
Thank you. My problem in all the different versions I tried was I was counting from row A instead of the first column of the array.
Thank you very much!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks