HLOOKUP Function

[Jason]

Frustrating problem with a lookup. Example:
Column A Column B Column C Column D
Sunday Monday
5 10 12 7

I want to be able to perform a lookup to see the 2 values
for sunday for example in Column A and B. Using the
HLOOKUP function I can find Column A's value for Sunday
but I need to then go across 1 column to see the value
next to it in column B. Any help with this feature would
be gratefully received.
Many Thanks in advance!

 

[Guest]

Sounds like you really want VLOOKUP (vertical)

try arranging your tabel like this

Column A Column B Column C
Sunday 5 10
Monday 12 7

You can use the formula:
=vlookup(a1,a1:c3,3)

which means =vlookup(lookup value, lookuprange, column of
required value)

 

[Leo Heuser]

Jason

Assuming your data in A12, is this
what you're looking for:

=INDEX(A12,2,MATCH("Sunday",A11,0)+1)