Notifications
Clear all
Topic starter
Hi guys,
Anyone could help me to get the formula to return value to the next column/cell when the one beside is blank?
table attached.
Thanks
Jian
| CODE | ITEM PRICE | PRICE 2 | PRICE 3 |
| A110 | 22.28 | 44.56 | 69.00 |
| A112 | 27.50 | 55.00 | |
| A130 | 20.00 | 40.00 | |
| Code | PRICE | ||
| A110 | Need price 2 | ||
| A112 | Need price 3 | ||
| A130 | Need price 3 |
Posted : 07/05/2020 8:59 am
Somthing like this?
=IF(ISBLANK(INDEX(C:C,MATCH(H3,A:A,0)))=TRUE,INDEX(D:D,MATCH(H3,A:A,0)),INDEX(C:C,MATCH(H3,A:A,0)))
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)
Purfleet
Posted : 07/05/2020 9:29 am
Topic starter
Thanks Purfleet, Perfect! This is what I want. 🙂
Posted : 07/05/2020 10:41 am
