Vlookup in a macro

[cultgag]

Hi,

What I'm trying to do is search get a part number in a worksheet and
match that number with a separate .csv file that's open. I'm trying to
use Vlookup but am unsure of how to reference the .csv file any help
will be greatly appreciated!

TIA

Sheet1.Cells(row_Numb, 5).Value =
Application.VLookup(Sheet.Cells(row_Numb, 1).Value,
Inv.csv!$A$1:$G$250, 5, False)

This is what I have...

 

[Lonnie M.]

Hi, try giving these links a look. I prefer the Index/Match functions
over VLookup because you are not constrained by the order the table is
arranged or sorting.

http://www.contextures.com/xlFunctions03.html

http://www.contextures.com/xlFunctions02.html

http://www.cpearson.com/excel/lookups.htm

HTH--Lonnie M.

 

[Bob Phillips]

Try

Application.VLookup(Sheet.Cells(row_Numb, 1).Value, _
Worksheets("Inv.csv").Range("$A$1:$G$250"), 5, False)


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[cultgag]

Thnx for the help and the quick response! This site is perfect!

 

[Bob Phillips]

Actually, no-one on the site responded. You got one response from a guy in
Google, and mine was from within the public NGs <G>