Formula to look in different tables

[hutch@edge.net]

Greetings, Gurus.

I don't know what I'm doing wrong here. All I'm trying to do is enter a formula that looks up a value typed in D2. If it doesn't find a match in the first table, I wan't it to look in an alternate table. Here's the formula:

=IF($D$2="","",IF(VLOOKUP($D$2,data2,1,FALSE)="#N/A",VLOOKUP($D$2,data3,1,FALSE),VLOOKUP($D$2,data2,1,FALSE)))

If the formula finds a match in the table named "data2", then it displays the results correctly, but if it doesn't find a match in "data2", it keeps returning #N/A, even if I know there is a match in "data3".

Thanks in advance for any help you can offer.