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)