Forum Discussion
Do I need to write an IF Then function with Vlookup nested?
Hello, I am trying to update the cost column by pulling the new cost from another work book. I had tried to use a VLOOKUP function but not all skus in column A appear in the other sheet. My qu...
Hi Luke_Hively
just combine a VLOOKUP with the IFERROR-function.
Let's assume, the list with new cost prices are in columns I and K.
You would add a new column E to your old list to find the new cost price, using this formula:
=IFERROR(VLOOKUP(A2;$I$2:$J$3;2;FALSE);D2)
So if VLOOKUP returns an error, which means, the SKU is not on the new list, then it just takes the old price from column D
Hello Martin_Weiss - I also need similar assistance.
I need to the criteria from Sheet 2 columns A & B to match Sheet 1 with return data from column H
Sheet 1
Sheet 2