Jian Guan
Active Member
Members
Forum Posts: 4
Member Since:
June 21, 2013
June 21, 2013
Offline
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 |
Purfleet
England
Member
Members
Trusted Members
Trusted Members
Forum Posts: 414
Member Since:
December 20, 2019
December 20, 2019
Offline
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
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Jay Quick, Olga Parkhaeva, Paul Byrne, Sheila Sanders
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1909
SunnyKow: 1432
Anders Sehlstedt: 899
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 279
lea cohen: 245
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Sheila Sanders
Francine Walshe
Sean Ladlow
Jorge Chicas
mahmoud salem
Irvine Choolo
Deon Bouwer
Amgad Squires
jim bo
Linda Bock
Forum Stats:
Groups: 3
Forums: 24
Topics: 6834
Posts: 29981
Member Stats:
Guest Posters: 49
Members: 33567
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —