T
treasuresflemar
I have a named Range "Price"
Ihave the folowing formula that works fine
=IF(B3>0,VLOOKUP(B3,Price,3,FALSE),"")
Except in column A I have a Manufactures name.
Column B contains the part number.
I want to only use vlookup on range "price" for matches to column a
What is the best way to handle this?
Thanks
Ihave the folowing formula that works fine
=IF(B3>0,VLOOKUP(B3,Price,3,FALSE),"")
Except in column A I have a Manufactures name.
Column B contains the part number.
I want to only use vlookup on range "price" for matches to column a
What is the best way to handle this?
Thanks