Is there a Formula to ...

[SarahB]

I am working on a spreadsheet where i enter a part number in one colum and then a alternate part number in a different colum. Does anyone know of a formula that will automaticly enter in the second part # in the other colum one i put the 1st part number on the work book ??

Thanks
SarahB

[SteveG]

SarahB,

You could set up a table with the primary part numbers in one column and it's alternate part number in the second somewhere in your sheet say D1:C100. Then you could use a formula like,

=VLOOKUP(A1,D1:C100,2,FALSE)

When you enter in the primary part number, this will look it up and retrieve the alternate part number in the table. To avoid getting an N/A error you can modify to:

=IF(ISNA(VLOOKUP(A1,D1:C100,2,FALSE)),"Part Not Found",VLOOKUP(A1,D1:C100,2,FALSE))

HTH

Steve