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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLOOKUP and choose one value among 2 values
A B C D E F G Property River Forest Mountain Month March April March April March April Rent 30 40 35 45 65 70 To get March data for "River" =INDEX($B$3:$G$3,0,MATCH("River",$B$1:$G$1,0)) To get April data for "River" =INDEX($B$3:$G$3,0,MATCH("River",$B$1:$G$1,0)+1) Change "River" to "Forest"/"Mountain" for equivalent HTH "Positive" wrote: 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 |
Reply |
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) |