ExcelBanter - Looking up a value from an array table

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Looking up a value from an array table (https://www.excelbanter.com/excel-worksheet-functions/48352-looking-up-value-array-table.html)

Looking up a value from an array table

I have a table within a spreadsheet that looks like this....

JBK CBW AKB JVH RGM
10 776 793 810 827 844
20 724 741 758 775 792
30 672 689 706 723 740
40 620 637 654 671 688
50 568 585 602 619 636

Cell X99: __AKB_
Cell X100: __40__
Cell X101: __671__

I want to be able to enter the Name (in this case AKB) and the number (40)
and get the number at the intersection....671.

What formula should I use for that?

Thanks

Assume your table is in A1:F6

=OFFSET(A1,MATCH(X100,A2:A6,0),MATCH(X99,B1:F1,0))

Kiser Wrote:
I have a table within a spreadsheet that looks like this....

JBK CBW AKB JVH RGM
10 776 793 810 827 844
20 724 741 758 775 792
30 672 689 706 723 740
40 620 637 654 671 688
50 568 585 602 619 636

Cell X99: __AKB_
Cell X100: __40__
Cell X101: __671__

I want to be able to enter the Name (in this case AKB) and the number
(40)
and get the number at the intersection....671.

What formula should I use for that?

Thanks

--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=472698