Vlookup in a macro
 

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...:confused:


--
cultgag
------------------------------------------------------------------------
cultgag's Profile: http://www.excelforum.com/member.php...o&userid=22677
View this thread: http://www.excelforum.com/showthread...hreadid=512283

Vlookup in a macro
 

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.

Vlookup in a macro
 

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" wrote in
message ...

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...:confused:


--
cultgag
------------------------------------------------------------------------
cultgag's Profile:
http://www.excelforum.com/member.php...o&userid=22677
View this thread: http://www.excelforum.com/showthread...hreadid=512283

Vlookup in a macro
 

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


--
cultgag
------------------------------------------------------------------------
cultgag's Profile: http://www.excelforum.com/member.php...o&userid=22677
View this thread: http://www.excelforum.com/showthread...hreadid=512283

Vlookup in a macro
 

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

"cultgag" wrote in
message ...

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


--
cultgag
------------------------------------------------------------------------
cultgag's Profile:
http://www.excelforum.com/member.php...o&userid=22677
View this thread: http://www.excelforum.com/showthread...hreadid=512283