View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Svenvlad
 
Posts: n/a
Default Lookup with multiple conditions


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