I have a file (FILE1) that has last-name (Col A), first-name (Col B), address (Col C).

I have a second file (FILE2) that is linked to FILE1 only in Col A.


Problem: Working only with FILE2, can a formula be written for Col B (first-name) and Col C (address) that is based off of the formula in Col A?? Sort of like asking if you can take the formula in FILE2 cell A1 and "change the A into a B" to get the first-name to populate in cell B1 ... and "change the A into a C" to get the address to populate in cell C1.

Thanks for your help!
Frank

P.S. couldn't get the files to attach??? so here's the issue in simplicity

FILE1:
COL A COL B COL C

SMITH BUD 228 MORING ST
JONES ANN 575 WATERS AVE
MAYES MAY 989 PALM CT



FILE2:
COL A COL B COL C

='FILE1'!$A$1 ? ?
='FILE1'!$A$2 ? ?
='FILE1'!$A$3 ? ?