Help with formula, offset with conditional

[GastonFranzini]

Hi, I need help with a formula,
I want to do a left lookup, As I have duplicates in the column G, match
the value in the cell I32 only if in the column B has the value that I
have in the column J32.
I tried this for a left lookup but I can`t put a conditional in it.
=OFFSET(G32,MATCH(I32,$G$32:$G$38,0)-1,-1,1,1)

Thanks
Gastón

 

[Bob Phillips]

Here is an example

=INDEX($A$42:$A$38,MATCH(1,($G$32:$G$38=I32)*($B$32:$B$38=J32),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

But you haven't said what the lookup column is, I have sghown with A.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

Hi, I need help with a formula,
I want to do a left lookup, As I have duplicates in the column G, match
the value in the cell I32 only if in the column B has the value that I
have in the column J32.
I tried this for a left lookup but I can`t put a conditional in it.
=OFFSET(G32,MATCH(I32,$G$32:$G$38,0)-1,-1,1,1)

Thanks
Gastón

 

[GastonFranzini]

Thanks!!!
Great solution!