How do I find a value at the intersection of a column and a row?

**brianalucas** · 04-01-2010, 07:06 PM

I'm sure this is basic but I'm hitting a roadblock.

I can find a value at the intersection of a column and a row if I use the Lookup Wizard but the wizard only works when the data range being referenced is within the same worksheet. But I need to be able to perform the lookup when the data source is in another worksheet and/or workbook.

I've attached a small .xls file that shows what i'm trying to do.

Would greatly appreciate any help you can offer. Thanks!!!!!
Brian
[email protected]

**ratcat** · 04-01-2010, 07:36 PM

G'day and welcome to the forum

Try this way and copy drag down

=INDEX(data!$B$2:$K$6,MATCH(A2,data!$A$2:$A$6,0),MATCH($A$1,data!$B$1:$K$1))

You have your row and column index the wrong way

Cheers

RC