Forum Discussion
Creating a VLOOKUP Formula
Hi, I wandering if anyone could help me. I am trying to create a formula in one sheet that will search if the corresponding item has been returned for a refund in another sheet and if it has to leave...
Presuming there are no repeats in the products sheet.
You can use something like this (Adjust the ranges accordingly for your data) :
=IF(VLOOKUP(L2,Sales!$A$2:$C$3,3,0)="Refund",Sales!B2,"")
If there are duplicates in the products sheet, you'll need something stronger. Still do-able.
Hi, thank you for getting back to me. Just a quick question, in your formula - what does the "Sales!B2" relate to?