How to lookup both Vertical and Horizontal

[bencyp]

Hi Guys,

I have few data which consists of Vertical and horizontal headings with values. These vertical and horizontal headings may vary its position but I need the correct value from the main sheet.

State Not So Good General Good
Mumbai 51 36 74
Dehi 33 27 46
Kerala 35 24 73
AP 34 27 46
Karnataka 56 24 78
Chennai 23 26 54
Kolkata 48 36 76
Gujarat 64 42 43

The above details will be the main sheet which may vary the horizontal and vertical headings.
IN the next sheet I will have some fixed headings which should pull the data from main.

Any help would be appreciated.

 

[jim may]

Do you mean something like this?

Excel Workbook
	A	B	C	D
1	State	Not So Good	General	Good
2	Mumbai	51	36	74
3	Dehi	33	27	46
4	Kerala	35	24	73
5	AP	34	27	46
6	Karnataka	56	24	78
7	Chennai	23	26	54
8	Kolkata	48	36	76
9	Gujarat	64	42	43
Main

Excel 2007

Excel Workbook
	A	B
1		General
2	Kerala	24
Sheet2

Excel 2007

Cell Formulas
Range	Formula
B2	=INDEX(Main!$B$2:$D$9,MATCH(Sheet2!A2,Main!$A$2:$A$9,0),MATCH(Sheet2!B1,Main!$B$1:$D$1,0))

 

[bencyp]

Thanks Jim for your reply.

Your example shows what I am looking for.

I am unable to get the desire results from the formula you have given. Can you please help Jim?

Regards,
Bency

 

[bencyp]

Sorry Jim,

Its working now. You are a Gem Jim.

Thank you very much. Will be needing your help more in future.

Regards,
Bency