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