VLOOKUP across two sheets in XL2007

[adamuk]

Hi, hope you can help me out, urgently need to solve this problem for work

I am attempting to use vlookup to search for a part number listed in sheet 1 and return the corresponding product description from sheet 2.

I'm using the following formula, but only producing a #ref! error, if I change the col_index_num to one, I can get it to return the original part number, but thats no good

=VLOOKUP($A$2,'MPN LOOKUP'!$A$1:$A$3504,2,FALSE)

Any idea where i'm going wrong?

In sheet 1 "BACK ORDERS" I have a list of part numbers in column 1, in column 2 is where I want the vlookup result. In sheet 2 "MPN DATABASE" I have a list of part numbers in column 1 and a list of product descriptions in column 2.

Any help would be hugely appreciated.

 

[VoG]

Try

=VLOOKUP($A2,'MPN DATABASE'!$A$1:$B$3504,2,FALSE)

 

[adamuk]

Thanks for the reply VoG

Thats now returning a #N/A error, thats a kind of progress

The data being looked up in sheet 1 definitely exists identically in sheet 2.

 

[VoG]

This should help http://www.contextures.com/xlFunctions02.html#trouble

 

[adamuk]

Got it working with =VLOOKUP(A2,'MP<wbr>N LOOKUP'!$A$1:$B<wbr>$3504,2)

It was the table_array inclusion of B that you suggested that fixed it.

Thanks so much!!!

I could kiss you!!!