I have a spreadsheet "franchise Stores" containing franchises in column "a"
and their stores store# in column "b", a simple database with most franchises
having more than one store. Every day different stores submit their problems
to us using only their store numbers. I have a seperate spreadsheet for these
calls "call log". I manually look up the stores franchise with the store
number using the Find Function in "franchise Stores", and copy, paste it to
"call log". Is there a way to have excel do this on its own? There are too
many to do this in a timely manual fashion.

Franchise Stores Call Log
A B A
B
Bobs franchise 123 678 ?????????
Bobs franchise 321 123 ?????????

Bills Franchise 678 123 ????????

One way is to use a VLOOKUP() formula in the Call Log tab's column B.