Macro/LOOKUP?

[Gamermatt]

Hey guys,

In column A I have a list of product numbers. In column B, I have a bigger list of product numbers that contains most of the product numbers in column A, and more. Then in column C, I have the corresponding prices to the product numbers in column B. I need lookup the each product number in column a in column b, then take the corresponding price and put it in column D. Although, some cells should be blank because there are some product numbers in column A that are not in column B.

Thanks in advanced.

Matt

 

[macness]

No macro needed:

You can use a vlookup like this

=if(isna(VLOOKUP(A1,$B$1:$C$20,2,FALSE)),"",VLOOKUP(A1,$B$1:$C$20,2,FALSE))

just change your range lookup for b1 to c whatever.

 

[Gamermatt]

No macro needed:

You can use a vlookup like this

=if(isna(VLOOKUP(A1,$B$1:$C$20,2,FALSE)),"",VLOOKUP(A1,$B$1:$C$20,2,FALSE))

just change your range lookup for b1 to c whatever.

Thanks