Hello, this is not working in my spreadsheet. I want to return the value in
'Shots' Column U by matching the value of B7 in 'Shots' column W AND matching
value of C7 in 'Shots' column AA to return the row value. Please note that
'Shots' is another spreadsheet. This is what I have and it is returning VALUE!

=INDEX(SHOTS!U:U,MATCH(B7&C7,SHOTS!W:W&SHOTS!AA:AA ,0))

Any ideas?

"cbuker" wrote:

Try this and use 3 conditions (A&B&C) instead of two.
:
By: Bob Phillips In: microsoft.public.excel.worksheet.functions


=INDEX(Sheet2!C1:C1000,MATCH(A1&B1,Sheet2!A1:A1000 &Sheet2!B1:B1000,0))

as an array formula, so commit with Ctrl-Shift-Enter

BTW, here is what I did:

=INDEX($G$2:$P$1137,MATCH(A23&E23,$H$2:$H$1137&$I$ 2:$I$1137,0),6)

where the result I want is in the 6th column of $G$2:$P$1137, A23 and E23
are the values I am trying to match with values somewhere in columns H and I,
respectively, and I require an exact match (0).

Thanks Bob and Dave, and others.




"Svenvlad" wrote:


G'day all,

I was just wondering if there was a way to return a value from a data
table by specifying *3* conditions to be met.

Eg. My data table is in cells W1:Z100
(Column names = Track, Distance, Class, Time)

I want to be able to return the time value, based on track, distance
and class values.

Thanks in advance,

Sven


--
Svenvlad
------------------------------------------------------------------------
Svenvlad's Profile: http://www.excelforum.com/member.php...o&userid=28916
View this thread: http://www.excelforum.com/showthread...hreadid=490493