Forum Discussion
Boe Dillard
Feb 12, 2024Iron Contributor
Help copying the name assigned a phone number name anywhere in a spreadsheet to the next occurrance?
Hello, Every month I take all the phone calls I've received - some have the name of the phone number next to them - some don't and add it as a new sheet to a spreadsheet. The workbook has two yea...
HansVogelaar
Feb 12, 2024MVP
Insert an empty column in column C,
In C2:
=XLOOKUP(A2,A$2:A2,B$2:B2,"")&""
Fill down as far as you want.
Boe Dillard
Feb 12, 2024Iron Contributor
Thanks - maybe I'm not explaining well.
I have a workbook with multiple pages. The first sheet of the workbook has A1 through B1000 filled in:
Sheet 1 (Phone#)
A1 818-555-1212 B1 Jane Doe
A2 818-555-1214 B2 John Doe
A3 818-555-1215 B3 Mary Smith
A4 818-555-1218 B4 Bob Smith
Sheet2 might be (NewCalls)
A1 818-555-1218 B1 blank/no value
A2 818-555-1214 B2 blank/no value
I want to have the second sheet reference the values in the first sheet to fill in for B1, B2...
I think it would be something on the second page in column C =XLOOKUP(A1,'Phone#'!A$1:A$1000,'Phone#'!B$1:B$1000)
Unfortunately that gives me the phone number instead of the name so I'm off somewhere.
- Boe DillardFeb 13, 2024Iron ContributorGot it - solved =XLOOKUP(B4,'Phone#'!B$1:B$1000,'Phone#'!A$1:A$1000)
Thanks