Vlookup help!

**dans123** · 04-01-2012, 09:41 PM

Hi All,

I have a database on sheet 1 and a table on sheet 2.

In column A on sheet 2 i have names and im trying to formulate a VLOOKUP that will deliver the word that is column 13 in the database on sheet 1 to the table in sheet 2, once the names match.

=VLOOKUP(A5,Sheet1!1:65536,13,FALSE)

thats what i have but i keep getting a #NA

Any help will be greatly appreciated!

**FDibbins** · 04-01-2012, 09:46 PM

looks like you have omitted the column reference in your formula?

=VLOOKUP(A5,Sheet1!A1:C65536,13,FALSE)

**dans123** · 04-01-2012, 09:52 PM

Thanks for the reply FD, I tried changing from just selecting the entire worksheet to the actual database, but the problem still remains. I get NA instead of the word that corrosponds to the name.

=VLOOKUP(A5,Sheet1!A1:V59337,13,FALSE)......................My updated formula.

**FDibbins** · 04-01-2012, 10:15 PM

what word are you looking for, and what word are you basing your search on? If you can manually find a mathc, try using =exact() on the 2 to see if they are exactly the same.

failing that, i see that is it a large database. can you upload a small sample, or dummy data?

**dans123** · 04-01-2012, 10:43 PM

I'm looking for what bank a person is with, so in the database i have a list on names and then a few columns over the banks name (this of course differes for each person), and im trying to vlookup a bank based on which person it is. I just created a sample but it worked fine on that, i don't understand why its not working on the actual data.

Ofr most their name is entered in the database multiple times (but the bank name is the same) could this be throwing it out?

**FDibbins** · 04-04-2012, 03:21 PM

if the data you are trying ti find, is to the left of what you are doing your search in, vlookup wont work. in other words, you cannot lookup something that is minus 3 columns to the left. for that, you have to use use the index/match combination. it works as follows...

=INDEX(A12:B19,MATCH(F18,B12:B19,0),1)....

1st, you find the match() for what you are looking for, in the above, you are looking the the contents of F18, in the range B12:B19 - the 0 specifies an exact match. That gives you the row mumber of the item you are looking for.

You then use the row number for the index() portion to return the value in the row (from match) in the 1st column

If you can send me a sample, it will be easier to get you started on what you need