IF for 2 different sheets

[cogumelo]

Hi.

I thought this would be pretty straightforward but i've come around a few problems with IF.

IF($BY$1=HLOOKUP($BY$1;sheet1!1:1;1;0);OFFSET(sheet1!$B$1;MATCH(A2;sheet1!$A$2:$A$1000;0);MATCH($BY$1;sheet1!$C$1:$GA$1;0))+BX2;OFFSET(sheet2!$B$1;MATCH(A2;sheet2!$A$2:$A$1000;0);MATCH($BY$1;sheet2!$C$1:$GA$1;0))+BX2)

What i'm trying to do here is:

IF($BY$1=HLOOKUP($BY$1;sheet1!1:1;1;0);

If sheet1 has the value on BY1 then:

OFFSET(sheet1!$B$1;MATCH(A2;sheet1!$A$2:$A$1000;0);MATCH($BY$1;sheet1!$C$1:$GA$1;0))

So far works fine if it finds the value on sheet1.

However if the value is not on sheet1 i need to do the same on sheet 2

OFFSET(sheet2!$B$1;MATCH(A2;sheet2!$A$2:$A$1000;0);MATCH($BY$1;sheet2!$C$1:$GA$1;0)))

But all i get is the N/A error.

Can anyone help out?

Putting it simple what i'm trying to do is get a value from the sheet that has the title i'm searching.


thx in advance,

cogumelo