Hi,

I have a spreadsheet that I have to return a specific value based on two
criteria, a state and loan amount.

My columns are loan amounts while my rows are states.

To complicate the situation, i have several companies to choose from in
between a range of loan amounts. For example, my loan amount range is
0-250,000 but I have to pick the highest number from company A, B, C. (by
the way, the loan amounts are in different cells, Like C3 and D3)

So my spreadsheet looks some what similar:

0.00-250,000
A B C D
AK 50 60 10 Q
AL 10 Q 80 70
AR Q 50 60 0

So I have my state as AK, I need to return 60. Would this complicate the
situation with having the Q's also in the table?

I tried to combine both an Hlookup and a Match forumla however I could not
make it work.