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
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
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.
- Thank you SO much Riny. I feel once I can dissect your solution, I'll finally understand how this works and be able to apply it. Have a great day! - Thom
