So VLOOKUP Sucks In 2010. Now What?

[flyonthewall]

I'm so unbelievably frustrated. It used to be that I could pick any cell, have excel look on another "data" sheet, and it would tell me whatever I wanted to know from that row. Now, for some reason, they made it incredibly temperamental and I can't seem to get it to work.

I'm basically making an order form that, ideally would spit out product features if given a product number. I've set up the spreadsheet such that the cell I want to look up is in column A (in this case, A21) and then I'm referencing the same column as my table array in the formula, just on a different sheet (ProductSelect).

TLDR: I want to look up the value in A2 on my current sheet, on PRODUCTSELECT in column A. I want to know what the value is in column be for that item number.


My code, thus far, is as follows:

=VLOOKUP(A21,ProductSelect!A:A, ProductSelect!B:B, FALSE)

wtf am I doing wrong? I've done this a gazillion times in 2003.

 

[flyonthewall]

Also! If there's a better formula for this now, I'd love to hear about it

 

[shg]

Did you mean =VLOOKUP(A21,ProductSelect!A:B, 2, FALSE)

 

[flyonthewall]

oh.my.god. i totally forgot the column was a number now.

i think i might love you. would that be weird?

thank you!

 

[shg]

It was always a number.

You may be thinking of INDEX/MATCH.