You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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.