LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup with multiple conditions Sachin Narute Excel Discussion (Misc queries) 2 August 2nd 05 07:02 AM
Lookup with multiple conditions linglc Excel Discussion (Misc queries) 4 July 28th 05 04:44 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Multiple lookup value's rucker31 Excel Worksheet Functions 0 March 11th 05 11:17 PM
SUM based on multiple conditions - SORRY, URGENT!!! marika1981 Excel Worksheet Functions 4 February 18th 05 11:13 AM


All times are GMT +1. The time now is 05:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"