I'm trying to use vlookup to match some part numbers with data in a .csv
file and so far have been unsuccessful. The highlighted portion keeps
on giving a "Subscript out of Range" and when I scroll over
range_lookup it gives me a message reading "range_lookup = nothing"
lookup_row_value = Sheet3.Cells(row_Numb, 1).Value
*Set Range_Lookup = Workbooks("Inv.csv"). _
Worksheets("Sheet1").Range("a1:g400")*
found_value = Application.VLookup(lookup_row_value, _
Range_Lookup, 5, False)
Sheet3.Cells(row_Numb, 5).Value = found_value
TIA
Matt
--
cultgag
------------------------------------------------------------------------
cultgag's Profile:
http://www.excelforum.com/member.php...o&userid=22677
View this thread:
http://www.excelforum.com/showthread...hreadid=512718