| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLOOKUP with 2 values and choose 1 value
Hi,
I have a spreadsheet with property names, months and rents lay out horizontally. Each property name takes up 2 cells, of which underneath are May and June and rent amounts for May and June. Can i use HLOOKUP to just select the rent under May? Ex: Property |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HLOOKUP and choose one value among 2 values | Excel Worksheet Functions | |||
| using hlookup with sum/choose? | Excel Discussion (Misc queries) | |||
| How do I put combo box values into cells (without using @CHOOSE) | Excel Worksheet Functions | |||
| CHOOSE function - Possible with 100 values??? | Excel Discussion (Misc queries) | |||
| How do I choose multiple values in a drop down box? | Excel Discussion (Misc queries) | |||
Threaded Mode
