# VLOOKUP question

#### Executioner

##### Board Regular
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.

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Try this formula in row 2 copied down

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

=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.

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.

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

Replies
0
Views
401
Replies
1
Views
192
Replies
2
Views
276
Replies
1
Views
377
Replies
1
Views
1K

1,203,317
Messages
6,054,706
Members
444,742
Latest member
jmartin9247

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back