LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Lookup or reference function needed

I have a table that I return specific values when two conditions are true:

E H M L
SI 700 600 500 400
DI 550 400 300 250
WM 550 400 300 200
BS NP 400 300 250
EB NP NP 250 250

For example, when two test are true, they return one of the values: i.e. if
SI and E occur, return 700. If SI and H occur, return 600.

I've tried the lookups, or, and, and several other functions, and can't seem
to find one that allows me two variables to return a value.
--
Thanks for your help.
 
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
Need some comments on my Utility_Move class module. jchen Excel Worksheet Functions 0 August 21st 06 07:05 PM
Lookup function and compare Student Excel Discussion (Misc queries) 8 April 25th 06 03:11 PM
Don't understand Lookup function Beblessed New Users to Excel 1 March 1st 06 08:57 AM
lookup function 1 Colboyfx Excel Worksheet Functions 4 July 15th 05 09:15 AM
Lookup function problem (kg) greencecil Excel Worksheet Functions 3 July 1st 05 04:54 PM


All times are GMT +1. The time now is 07:17 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"