View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LFleming LFleming is offline
external usenet poster
 
Posts: 1
Default Setup of an IF AND statement

I have a spreadsheet that needs to lookup a value but it is dependent on two
values.

Master Sheet reads
A B C
74% 5 (need lookup value)
83% 4 (need lookup value)
The C column needs to be the lookup value for both A & B

My Lookup values
A B C
1 0% 74% (The range for C is 60%-150%)
2 2.5% 74% (The range for C is 60% -150%)
3 3.5% 74% (The range for C is 60% -150%)
4 5.0% 74% (The range for C is 60% -150%)
5 7.0% 74% (The range for C is 60% -150%)

Please help