Formula for Unique ID mapping of 4 cells

[Azmar]

Hello, I attached an image and excel sheet showing what I want to accomplish. Pretty much I have numbers at bottom of my excel sheet where if I say 1 it would map to 4 cells that would be displayed up above exactly. I would like a nice simple formula where I could up above say #1, and it would look down below where ID 1 is and map to the 4 cells up above where I said #1. Of course the reason I am posting is because I want to map to 300+ possibilites where I only care about the Slot # and if I input that, it would automatically map it from the data below.

Yes I could use IF statements, but I have around 300+ unique ones I need to map to and that would not be realistic.

Thanks for the help!

ANSWER: Search for INDEX and MATCH combined in a simple format.

[FDibbins]

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

[Azmar]

Ok I believe I fixed everything!

[Azmar]

Is there no formula that can easily accomplish this? I am still having troubles with this. I am open to different ways of doing the same thing too, if anyone has any advice.

Thanks

[FDibbins]

For E21 down, try this...
=INDEX($B$11:$E$18,MATCH("*("&$B$21&")",$A$11:$A$18,0),MATCH($D21,$B$1:$E$1,0))
(not sure that answers your question though?

[Azmar]

Got it solved thanks! After you posted that I looked more into INDEX and MATCH and the answer was a simpler format. Thanks!

[Indi_Ra]

For E21 down, try this...
=INDEX($B$11:$E$18,MATCH("*("&$B$21&")",$A$11:$A$18,0),MATCH($D21,$B$1:$E$1,0))
(not sure that answers your question though?

May I ask you FDibbins?
How did you deduce that in cell E21 OP need formula, that you have posted.
You have a magic ball?

[FDibbins]

Indi, no, my batteries for the magic ball died, I need to get some more lol

OP said they wanted to replace multiple IF statements, that was where I saw them being used - figured if I gave INDEX/MATCH for that, OP could adapt for other places

[Indi_Ra]

You need an UPS 😅 for your ball
UPS Uninterruptible Power Source