Thanks Jim,

This is not working for me ???

Jim Thomlinson wrote:
You can use ISNA to determine if a Vlookup is going to return something. So
you could do something like this...

=if(isna(vlookup(A1, sheet2!a1:d100, 2, false)), vlookup(A1, sheet3!a1:d100,
2, false), vlookup(A1, sheet2!a1:d100, 2, false))

Hello All,

[quoted text clipped - 10 lines]

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200802/1