Excel Question

[nikaiyo2]

Can anyone help with my formula...

=IF(U2,">0.5",INDEX(Sheet2!C:C,MATCH(Sheet1!H2,Sheet2!A:A,0)))

To me that should be if U2 is greater than 0.5 return the index match... but it is clearly wrong as if U2 is greater than 0.5 it returns >0.5.

What have I got wrong ?

[selwonk]

I think this is right:

=IF(U2>0.5, INDEX(Sheet2!C:C, MATCH(Sheet1!H2, Sheet2!A:A, 0)), "")

[Harpoon]

I might be mis-reading it but to me there's no conditional check to test, just U2.

=IF(logical_test, [value_if_true], [value_if_false])

eg

=IF(U2>0.5, true, false)

[nikaiyo2]

selwonk said:

I think this is right:

=IF(U2>0.5, INDEX(Sheet2!C:C, MATCH(Sheet1!H2, Sheet2!A:A, 0)), "")

Thats the one


Thanks for the help