Index, Match again.

Question

Index, Match again.

I asked yesterday but didn't get an answer. I watched some YouTube videos and this should work but it doesn't. From what I saw transposing the Rows and Columns should have made it work.

I'm trying to get this to work but as of yet nothing . On the Points table B3 and C3 are Pop-Up Menus . I need to get the points from The Core Units table depending on the Pop-Up choices . I was using IF, IFS, Switch but as I add more tanks to the table they quickly became unwieldy to write. I know this will work but can't get it to do so.

If anybody can write a working formula I'd be very grateful as I'd be using it in a lot of tables in this sheet.

Thanks for any help with this.

Mac mini (M2 Pro, 2023)

Posted on Oct 29, 2024 1:04 PM

Reply

Answer 1

Yellowbox

Level 7

21,197 points

Oct 31, 2024 2:09 AM in response to franks4business

Hello again franks4business,

You wrote: I asked yesterday but didn't get an answer.

Yes you did. I replied with my cheat sheet for INDEX MATCH but you did not respond.

Frank, you have not received any more replies and I think that is because no-one can understand your overall aim.

Perhaps this years-old reply from me will help. It is an "Index Match 2 way" example. Sorry, I can't find that discussion. This is what I saved.

Formula in "Active in these years" B2 is INDEX(Data::$B,MATCH($A2&"-"&B$1,Data::$C,0))

Now to get rid of those red error triangles by wrapping IFERROR around the formula

IFERROR(INDEX(Data::$B,MATCH($A2&"-"&B$1,Data::$C,0)),$A2&" or "& B$1&" not found")

And Conditional Highlighting (Text does not contain "not" > Green Fill)

I realise that this does not answer your question, but I do not understand your question. That is all I can do. See this User Tip: Writing an effective Apple Support Communities question

https://discussions.apple.com/docs/DOC-5931

Regards,

Ian.

Reply

Answer 2

Oct 29, 2024 1:54 PM in response to franks4business

OK, I think I figured it out. Might not be exactly correct but it works.

Reply