How to add to "IF" formula?

What I’d like to do is depending on what is chosen from the drop down box I would like for it to bring it up on cell B7-D7.

I’ve managed to bring over John but what if Joe was chosen? How would I add to the same formula where if Joe is chosen to bring his information instead?

In this case John = 2, Joe =3, Mary =4 and Jane =5…

Oh and any recommendations on what reading will help me understand on how to add more criteria to a formula??

Try:

=IFERROR(INDEX($J$12:$L$15,$O$1-1,COLUMNS($A$1:A$1)),"")

copied across.

That indicates the column number from the table to get the info from...

COLUMNS($A$1:A$1) is equal to 1

as you copy it to next column you get COLUMNS($A$1:B$1) which equal 2 and then to next column COLUMNS($A$1:C$1) equals 3

you can replace with hard-coded 1, 2 and 3 if desired.

The $O$1-1 was just subtracting 1 from the linked cell value that appeared in O2 as a result of your selection... since you have a blank as the first selection the formula had to incorporate the offset of 1. I hadn't noticed that you had a different range of names to point your drop down list to in M3:M7... and I guess I assumed that the list in I12:K15 was the main list and therefore the names were listed in the same order...

So instead it would have been better to use:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

...but now with your new problem of duplicate matches, instead try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down as far as you need (without going too far as the formula becomes less efficient) and copied across the 3 columns.

Notice that the indexed range is not made absolute I.e. No $ signs before the Js so when you copy across it turns to Ks then to Ls. This is another technique that allows you to avoid using the Columns function to determine column number