Lookup and return value in table?

[kylesom]

Hi - have a quick and hopefully simple query, I've a feeling it needs the use of an Array formula which I've never been able to get my head round.

I have a table of values, column headings called A, E, I, O, U. Rows of the table are just 1,2,3,4, and values in the table itself are numeric.

I have 2 other formulas elsewhere that return in seperate cells that I'm interested in say Column E, and say Row 3.

I need a formula that looks up Column E, Row 3, and returns the corresponding value ("E3" doesnt correspond the absolute excel cell reference).

Any help would be appreciated...

 

[Trevor G]

Can you show an example of your table, and also what you are aiming for. Even if you just place some data in another area or anothe rexample when complete of how it should look.

 

[kylesom]

Can you show an example of your table, and also what you are aiming for. Even if you just place some data in another area or anothe rexample when complete of how it should look.

Don't have anywhere available to host the excel file so an image is the best I can do...

Note - the terminologies are different to my original post.

 

[Trevor G]

Please take a look at this sample. I am using Formula Called Index and Match, but with 2 options in the Match.

Excel Workbook
	B	C	D	E	F
1				Result	C
2				Class	Alpha
3				Answer	5f
4
5
6	Result	Alpha	Beta	Delta	Gamma
7	A	1n	2n	3c	4c
8	B	3d	4e	5e	5f
9	C	5f	2e	6f	6a
10	D	5e	3f	8a	3e
11	E	6g	4g	9a	2a
Sheet3

To gain an understanding perhaps look at this example website.

http://skp.mvps.org/xl00002.htm

 

[kylesom]

Thanks a million - I sorted it using a combination of IFstatements and HLookups (given that the table is quite small) - but I've bigger data sets I can use this on!

 

[Trevor G]

Pleased to read you have a working solution.