Thread: Vlookup in a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cultgag[_3_] cultgag[_3_] is offline
external usenet poster
  
Posts: 1
Default 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...


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

Reply With QuoteReply With Quote