HLOOKUP with 2 values and choose 1 value

P

Positive

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
 
B

bj

probably the simplest way would be to use a helper row which you can hide
in the helper row (3?)
in A3
=A1&A2
and in B3
=A1&B2
use the helper row as you lookup row and have your lookup value be the
equivelant of A1&A2
 
T

Toppers

Replied to your first posting as shown below:

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
 
Top