Vlookup Help

Hi,

I know this is pretty basic, but I'm having some trouble.

Sheet 1
Account number Business Type
0001 Grocer
0002 Clothing
0003 Electronics

Sheet 2
Account Number Business Type
0001 x
0001
0002
0003
0003
0001

So I want a formula that inserts the Business type value into the sheet 2 column depending on the account number and corresponding value in sheet 1.

Thanks!

Try

-VLOOKUP(A2,Sheet1!A:B,2,False)

Thank you,

For the col_index_number, I assigned it to sheet 1 column 2. As that serves as the output value I want, correct?

I tried that and got a #REF! response.

No, you use 2 as I showed.

Specifically:

-VLOOKUP(A2,Sheet1!A:B,Sheet1!2,False)

and this didn't work

Originally Posted by domnisignis18

Specifically:

-VLOOKUP(A2,Sheet1!A:B,Sheet1!2,False)

and this didn't work

Sorry, didn't see I had put that.

Of course, that's not the issue. Thanks for pointing that out though.

What I have is =VLOOKUP(A4, 'Membership Application'!A:BA, 2, FALSE)

and that output is #N/A but I know that that can't be right.

Trying making sure what you are looking up is the same as the table you are looking up. The second part is the range (or named range), of the table in Sheet1. The third part is the column you want to see. In this case, it is column 2.