nick99
07-23-2007, 08:19 AM
I am trying to use a simple excel function here ?Lookup?.
I have used this function several times; however in this case I am having a lot of problems.
I have two sheets. Sheet 1 has ?T-Codes? and Sheet 2 has ?T-codes? and ?VIN#?s?.
I have to basically pull the respective VIN #?s from sheet 2 for the T-Codes on sheet 1.
Formula on sheet 1. Cell A1
LOOKUP(E2,Sheet2!B:B,Sheet2!A:A)
However the problem I am running into is; if Lookup cannot find the T-Code on sheet 2, it gives me some arbitrary VIN# value.
Also sometimes there will be a T-Code on Sheet 2, but lookup will be confused and give me a zero value on sheet 1.
I have arranged columns on both the sheets in an ascending manner and the category defined for all the columns is ?General?
The advanced problem I have is I am trying to create a template, so these numbers will change on an everyday basis and lookup has to work efficiently each time.
The data is going to be extensive and I cannot afford to give a wrong VIN# to a T-code.
Please refer to the attachment
Is there some other way I can handle this situation?
Thank you all
I have used this function several times; however in this case I am having a lot of problems.
I have two sheets. Sheet 1 has ?T-Codes? and Sheet 2 has ?T-codes? and ?VIN#?s?.
I have to basically pull the respective VIN #?s from sheet 2 for the T-Codes on sheet 1.
Formula on sheet 1. Cell A1
LOOKUP(E2,Sheet2!B:B,Sheet2!A:A)
However the problem I am running into is; if Lookup cannot find the T-Code on sheet 2, it gives me some arbitrary VIN# value.
Also sometimes there will be a T-Code on Sheet 2, but lookup will be confused and give me a zero value on sheet 1.
I have arranged columns on both the sheets in an ascending manner and the category defined for all the columns is ?General?
The advanced problem I have is I am trying to create a template, so these numbers will change on an everyday basis and lookup has to work efficiently each time.
The data is going to be extensive and I cannot afford to give a wrong VIN# to a T-code.
Please refer to the attachment
Is there some other way I can handle this situation?
Thank you all