VLOOKUP question

[Executioner]

I have one column of data numbers column B & C. It continues to row 1619.
B---------------C--------------H
AssetNum-------WONUM--------SELECT RECORDS
3266------------385028--------3366
3281------------382905--------3481
3285------------383058--------3496
3366------------383155--------24976
3592------------383037--------16173
3481------------383105--------7282
3496------------378542--------4449

In column H, I have an index statement that selects records for me from column B. What I need is for VLOOKUP to select the matching record in column C with the one in column H. I tried this but it returns #NA:
=LOOKUP(H2,C2:C1619,1) in column I. Don't know what I'm doing wrong.

 

[barry houdini]

Try this formula in row 2 copied down

=VLOOKUP(H2,B$2:C$1619,2,0)

 

[hkaplan2]

Instead of:
=LOOKUP(H2,C2:C1619,1)

Try

=VLOOKUP(H2,C2:C1619,1,false)

The value in H2 must be in the column c range or you will get the error. FYI the values in your table example don't show any matches so it is not clear exactly what you want to retrieve in your vlookup.

 

[Executioner]

I tried Barry's and it worked. Can you explain the sequence of the calculation? Thanks for your help.

hkaplan2, I tried yours but get the same error message of #NA. The spreadsheet has over 1500 rows of data numbers. While reviwing the help file, and other VLOOKUP questions posted on this board, several mentioned that the values must be numeric. Mine were text, so I got them convered to numeric format. Don't know if that was an issue either, but thanks Barry for your help.

 

[barry houdini]

With this formula

=VLOOKUP(H2,B$2:C$1619,2,0)

H2 is the lookup value. That's "looked up" in the first column of the range specified, i.e. in column B, then the 2 specifies the column from which a value must be returned, in this case the 2nd column of the range, i.e. column C. The zero at the end (you can use FALSE as well) specifies an "exact match" only.

It doesn't matter if the values are text or numeric as long as the formats match. If H2 is numeric then B2:B1619 must also be numeric, if H2 is text then B2:B1619 should be text also