| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLOOKUP and choose one value among 2 values
Hi,
I have a spread sheet that formats assumingly for HLOOKUP. However, under the name of the property which takes up 2 cells, there are 2 values. For example, under Property RIVER , there are rent values for March and April. I only want to update one value. What formula should I use. Property RIVER FOREST MOUNTAIN Month Rent 30 40 35 45 65 70 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| listing values to choose from based on value in another cell | Excel Discussion (Misc queries) | |||
| How do I choose multiple values in a drop down box? | Excel Discussion (Misc queries) | |||
Threaded Mode
