Forum Discussion
Is an IF statement the best solution to display the desired data?
ThomT25 Sorry, I went a bit too quick earlier. The MATCH arguments were in the wrong order to begin with. And obviously we can't refer to the same cell called 'selection' in all areas. The attached works now and I trust you can get it to work on your end.
Riny_van_Eekelen
THANK YOU - Your solution worked perfectly until I found out the worksheet structure differs from the sample I provided. I spent the morning trying to adapt your solution to the new structure, with no success Here is the old vs. the new:
Could you update your formula for 1 cell (Location) to work with the new structure? I think once I see it, I can apply it to the other cells. Thank you - Thom
PS - I'm new to Office365 and can't figure out how to attach my Excel file from the cloud.
What you need to do that's to replace in Name Manager references for categories and choices (reference for categories becomes one for choices and the opposite). Formulae are the same.
and exchange 2nd and third parameters in INDEX formula.
SergeiBaklan
Thank you for your help. When I changed the worksheet structure, the information that Riny_van_Eekelen kindly provided did not work. I tried your suggestions with no success. Here are my latest results:I have attached the file below. Any help you can provide is greatly appreciated. Thank you!
ThomThomT25 some of the named ranges were set-up incorrectly. See attached.
Riny_van_Eekelen
My apologies. I should have included this screenshot in my last post. Here are the results I'm after:Are these results possible using the new table structure and the IF MATCH functions, or is there another way to achieve them? I've spent 8 hours re-defining the named ranges you provided, Googling, watching YouTube videos and even using ChatGPT but can't find a way to get the result I'm after.
Thank you again.
Thom
