I have a list of products with and with out product IDs.
Product(ID#)
Product
Product(ID#)
Product
Product(ID#)
Product
Product
Product(ID#)
In the column next to them I want it to display null if there is an ID.
If there is not an ID I want it to VLOOKUP to find the ID
This is the formula I have been trying to use.
IF(FIND("(",A5)>0, VLOOKUP(A5,'IMOS-RE'!$B$1:$W$300,3,FALSE), "Null")
I need the formula to rely on the parenthesis ( or ). They are the only character that is guaranteed to be only in the ones with IDs.
The problem I am having is that FIND errors with #VALUE because it does not find the "(".
Bookmarks