I need to consolidate some information, using several worksheets in one
file. Here's an idea of what I need to do:

WORKSHEET 1 - [/b]

_FIRST_|__LAST__|_COMPANYID_|_LOCATIONID_
BILL | SMITH | 1 | 3
JEN | JONES | 2 | 1

[b]WORKSHEET 2 -

_Company_ID_|__Name_
1 | Acme
2 | Widgets
3 | Bucky's

WORKSHEET 3 -

_LocationID___|__Name_
1 | New York
2 | Paris
3 | Rome

I need to come up with a set of formulas that give me the following
result:

WORKSHEET 1 -

_First__|_Last__|_CompanyID_|_LocationID_
Bill | Smith | Acme | Rome
Jen | Jones | Widgets | New York

Any ideas would be greatly appreciated!!

Jessica


--
sixpence668
------------------------------------------------------------------------
sixpence668's Profile: http://www.excelforum.com/member.php...o&userid=25472
View this thread: http://www.excelforum.com/showthread...hreadid=389209