The VLOOKUP function is what you seek...........check out the help section
and post back if you have specific questions.

Vaya con Dios,
Chuck, CABGx3



"MerlinGirl" wrote in message
...
Is there a way to get around the limitations of the IF function? I'd like
to
be able to enter a number in one cell and have other cells be
automatically
filled in based on data from another worksheet.