Create target cell from multiple cell results ?

[SteveP44]

I am looking for a solution to allow me to quickly retrieve information from a reference list within excel.

Lets say I have 4 lists of information for events. These located in columns AF, AM, BF and BM

On the working area, I have 4 cells.
Cell 1 = user types "A" or "B" (Event classification A or B)
Cell 2 -= User types "F" or "M" (Event classification Female or Male)
Cell 3 = User types the entrants age

Cell 4 = to automatically retrieve the information from the list.

For example
Cell-1 Cell-2 Cell-3 Cell-4
A F 55 =AF55


Any ideas ??

 

[JustynaMK]

Assuming that your Cell 1, Cell 2 and Cell 3 are in A1, A2 and A3, you can use INDIRECT function in cell A4:

=INDIRECT(A1&A2&A3)

INDIRECT function will then retrieve the value from cell AF55.

 

[SteveP44]

Awesome, and very simple solution. Thank you very much.

Assuming that your Cell 1, Cell 2 and Cell 3 are in A1, A2 and A3, you can use INDIRECT function in cell A4:

=INDIRECT(A1&A2&A3)

INDIRECT function will then retrieve the value from cell AF55.

 

[JustynaMK]

You're welcome! Glad it helps.