Please see attachment.
I have a Horizonal table of monthly salaries. In cell A2 there is a drop-down menu with a list of all the months. I want a formula that will be able to look-up the month from the table and gives me the salaries that correspond to that month. My formula is =HLOOKUP($A$2,$C$2:$N$4,3). I get bogus amount or #N/A. Please assist.
TIA,
ExcelNewby
You need to add the false statement
or could use=HLOOKUP($A$2,$C$2:$N$4,3,FALSE)
VBA Noob=INDEX($C$4:$N$4,MATCH(A2,$C$2:$N$2,0))
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
=HLOOKUP(A2,C2:N4,3,0)
should do the trick
I Love You Guys@exceltip!! It Works...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks