Hlookup with two conditions?

bnbrilhart

New Member
Joined
Jun 12, 2015
Messages
3
I am working with a file that includes year in one row and the month in the row below. I need a formula that can match the year and month and return the value directly below the month in the same column.

Thank you for any help!
 

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,301
Given

Code:
a a b
1 2 2
4 5 6
and lookup values of a and 2
=HLOOKUP("a",IF(A2:C2=2,A1:C3),3,0)
Array formula, use Ctrl-Shift-Enter

returns 5
 

Forum statistics

Threads
1,077,907
Messages
5,337,099
Members
399,125
Latest member
manibiotech

Some videos you may like

This Week's Hot Topics

Top