June 21, 2013
Anyone could help me to get the formula to return value to the next column/cell when the one beside is blank?
|CODE||ITEM PRICE||PRICE 2||PRICE 3|
|A110||Need price 2|
|A112||Need price 3|
|A130||Need price 3|
December 20, 2019
Somthing like this?
You can subtitute the index&match for a vlookup if you prefer or xlookup if you are on office 365.
(i moved the results table so the lookups didnt start looking at themselves in the same columns)