This seems like a simple problem to me, but I haven't got a clue where
to start.

I have two spreadsheets. Spreadsheet A contains teachers and the name
of the school they work at. Spreadsheet B contains all schools in the
state and the addresses.

I want to merge the address to the school onto spreadsheet A. In other
words, I would like the correct address to appear after the school name
for each teacher. The address will be in separate cells.

I assume a formula using functions would do this. Can you help?


--
rg3
------------------------------------------------------------------------
rg3's Profile: http://www.excelforum.com/member.php...o&userid=31291
View this thread: http://www.excelforum.com/showthread...hreadid=509611