Setup of an IF AND statement

L

LFleming

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rank and Sort 2
Use an "OR" around nested IF statements 2
VBA multiple list of values for variable 1
if value is between two numbers 6
Combo Box & value reference 1
How to use Sumifs with vertically and horizontally criterias 1
How to use Sumifs with vertically and horizontally criterias 3
Excel range lookup formula 1

Top