Forum Discussion
Solved
If cell contains specific text from one column, return value located in the same row
Hello, In the first sheet I have a table to calculate product prices, in the second sheet there is a list with product codes in one column and product price next to it. What I am trying to do is ...
=IFERROR(VLOOKUP(B6,Sheet2!$B$2:$D$1000,3,FALSE),"product missing in sheet2")
You can try a lookup formula. If the product doesn't exist in Sheet2 the formula returns a message.
=IFERROR(VLOOKUP(B6,Sheet2!$B$2:$D$1000,3,FALSE),"product missing in sheet2")
You can try a lookup formula. If the product doesn't exist in Sheet2 the formula returns a message.
- OliverScheurich
Thank you!
