Apple Intelligence is now available on iPhone, iPad, and Mac!

Index Match not working.

I'm trying to use Index Match and can't get it to work. I've tried using ChatGPT and it couldn't give me a working formula either. I need to Match the Pop-Ups in B3 and C3 using the table Core Units to give me the point number. I was using IF, IFS, Switch but as more tanks are entered the function gets very big and convoluted. Any help with this will be very much appreciated. Frank


I'm not sure where the formula in the pic came from, but the actual one is:

INDEX(,MATCH(B3,Core Units::A$2:A$13,MATCH(C3,Core Units::A:I)))


Mac mini (M2 Pro, 2023)

Posted on Oct 28, 2024 12:50 PM

Reply
1 reply

Index Match not working.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.