NateW
10-30-2007, 02:38 PM
Hi.
If you do a vlookup, and no corresponding value is found, what would the value transferred be with the following code:
Sheets("Gate Control").Cells(varRow, 9).Value = WorksheetFunction.VLookup(Sheets("Gate Control").Cells(varRow, 9).Value, _
Sheets("Carrier_Lookup_Table").Range("C3:D1000"), 2, False)
The reason I ask is I'm basing some later logic on the fact that if it searches for a corresponding value to "Zion Transport", and finds nothing, then
Sheets("Gate Control").Cells(varRow, 9).Value =
should equal 0. At least, that's what I'm thinking.
Any thoughts?
If you do a vlookup, and no corresponding value is found, what would the value transferred be with the following code:
Sheets("Gate Control").Cells(varRow, 9).Value = WorksheetFunction.VLookup(Sheets("Gate Control").Cells(varRow, 9).Value, _
Sheets("Carrier_Lookup_Table").Range("C3:D1000"), 2, False)
The reason I ask is I'm basing some later logic on the fact that if it searches for a corresponding value to "Zion Transport", and finds nothing, then
Sheets("Gate Control").Cells(varRow, 9).Value =
should equal 0. At least, that's what I'm thinking.
Any thoughts?