I think this might work for you:

=IF(ISERROR(VLOOKUP(B21,A52:B98,2,0)),"",VLOOKUP(B 21,A52:B98,2,0))

"Nelly" wrote:

Hi:

I already find a way to use several IF on a formula, but now I have another
question, is there a way that I can add 3 more IF to this formula but without
showing me the error message of: "Formula is too long".

Any suggestion to type this formual on another way??

Thanks for your help!
Nelly.

=IF(B21=A52,B52,"")&IF(B21=A53,B53,"")&IF(B21=A54, B54,"")&IF(B21=A55,B55,"")&IF(B21=A56,B56,"")&IF(B 21=A57,B57,"")&IF(B21=A58,B58,"")&IF(B21=A59,B59," ")&IF(B21=A60,B60,"")&IF(B21=A61,B61,"")&IF(B21=A6 2,B62,"")&IF(B21=A63,B63,"")&IF(B21=A64,B64,"")&IF (B21=A65,B65,"")&IF(B21=A66,B66,"")&IF(B21=A67,B67 ,"")&IF(B21=A68,B68,"")&IF(B21=A68,B68,"")&IF(B21= A69,B69,"")&IF(B21=A70,B70,"")&IF(B21=A71,B71,"")& IF(B21=A72,B72,"")&IF(B21=A73,B73,"")&IF(B21=A74,B 74,"")&IF(B21=A75,B75,"")&IF(B21=A76,B76,"")&IF(B2 1=A77,B77,"")&IF(B21=A78,B78,"")&IF(B21=A79,B79,"" )&IF(B21=A80,B80,"")&IF(B21=A81,B81,"")&IF(B21=A82 ,B82,"")&IF(B21=A83,B83,"")&IF(B21=A84,B84,"")&IF( B21=A85,B85,"")&IF(B21=A86,B86,"")&IF(B21=A87,B87, "")&IF(B21=A88,B88,"")&IF(B21=A89,B89,"")&IF(B21=A 90,B90,"")&IF(B21=A91,B91,"")&IF(B21=A92,B92,"")&I F(B21=A93,B93,"")&IF(B21=A94,B94,"")&IF(B21=A95,B9 5,"")&IF(B21=A96,B96,"")&IF(B21=A97,B97,"")&IF(B21 =A98,B98,"")