Formula missing parenthesis

[katieshields]

Please can someone help. I have created an IF formula (which is obviously incorrect). In cell I7 is the currency so depending on the currency in that cell will depend on which data I use from Sheet2. The formula I am using is

=IF($I$7=Sheet2!$B$2,Sheet2!B3,IF($I$7=Sheet2!$C$2,Sheet2!C3),IF($I$7=Sheet2!$D$2,Sheet2!D3,IF($I$7=Sheet2!$E$2,Sheet2!E3,IF($I$7=Sheet2!$F$2,Sheet2!F3,IF($I$7=Sheet2!$G$2,Sheet2!G3))))

I hope someone can understand the above and help me.

Thanks

Katie

[Ace_XL]

Try a simpler HLOOKUP or INDEX/MATCH combo

=HLOOKUP($I$7,Sheet2!$B$2:$G$3,2,FALSE)
or
=INDEX(Sheet2!$B$3:$G$3,MATCH($I$7,Sheet2!$B$2:$G$2,0))

[katieshields]

So simple, thank you

[rishikrsaw]

or simply use vlookup as below

=VLOOKUP(I7,TRANSPOSE(Sheet2!B2:G3),2,FALSE)

pls press shift + ctrl + and enter

many thanks
Rishi Saw