| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing Row by Row - A-D dollar amounts to E dollar amount
I thought the HLOOKUP would be sufficient. Not the case.
I have 4 dollar amounts in Row 1 (A1:D1) and a dollar amount in E1. E1 is the main value that must be compared to A1:D1 and the result is to return a value found in A1:D1 closest BUT not exceeding E1. Any suggestions or thoughts would be GREAT! Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total Dollar Amounts From Different Worksheet | Excel Worksheet Functions | |||
| column of dollar amounts don | New Users to Excel | |||
| Format dollar amounts for check printing | Excel Discussion (Misc queries) | |||
| Format dollar amounts for check printing | Excel Discussion (Misc queries) | |||
| dollar amounts | New Users to Excel | |||
Threaded Mode
