On Thu, 2 Oct 2003 10:23:37 -0400, "Tom Ogilvy"
wrote:

Assume you have data laid out as a table in another sheet
A B C C
Key Name Alias Serial Resouces
Roundup Monsanto 123-456 12 Hours
T-Other Something 86-222 6 Hours

Headers in Row 1

so in H10

=If($G10="","",Vlookup(G10,Sheet2!$A$1:$D$500,2,F alse))

in I 10
=If($G10="","",Vlookup(G10,Sheet2!$A$1:$D$500,3,F alse))

in J10
=If($G10="","",Vlookup(G10,Sheet2!$A$1:$D$500,4,F alse))

This will then do what you describe.


Tom,

I works!!! Thanks so much! You are definately a lifesaver!

Don