jmattingly85
New Member
- Joined
- Jul 12, 2010
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
I need some assistance with a lookup in Excel. I have the following data in my spreadsheet:
I need to look up from another set of data (posted below) to see if, based on the # of people, if the dollar amount column is below at or below the 50 column or the 60 column. For example the person listed in row 1 above would return 50. The person in row two would return 60 (based on the list below). Is this possible?
Dollar Amount | # of Persons |
$19,500 | 2 |
$36,410 | 1 |
I need to look up from another set of data (posted below) to see if, based on the # of people, if the dollar amount column is below at or below the 50 column or the 60 column. For example the person listed in row 1 above would return 50. The person in row two would return 60 (based on the list below). Is this possible?