Hi There - can anyone help plse.
I am trying to look up a region & product name combination in a table and returning the status (live or discontinued).
Unfortunately in the lookup up table the product name can either be a number or a group of letters.
Is there a way of looking up the numeric product name and if not then trying the alphabetical name.
As always much appraciated.
Thanks
Tom
Perhaps in J8 and copy down, this ARRAY formula.
=IFERROR(IFERROR(INDEX($D$8:$D$11,MATCH(G8&H8,$B$8:$B$11&$C$8:$C$11,0)),INDEX($D$8:$D$11,MATCH(G8&I8,$B$8:$B$11&$C$8:$C$11,0))),"Not Exist")
-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi,
See attached with helper column A
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thx for the quick responses. Both worked very well. Have a great weekend.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks