Names and addresses

[Steve]

I have an excel worksheet of clients names & addresses and want to complete a
separate sheet by typing in clients initials to lookup and find and add name
and address to a new worksheet

 

[Pete_UK]

Insert a new column A on your existing sheet and use this for the
initals of your clients - ensure that these are unique. Then on the
other sheet, assuming you use A2 to enter the initials, put this
formula in B2:

=IF($A2="","",VLOOKUP($A2,Sheet1!$A:$G,COLUMN(B1),0))

Then you can copy this across the row up to column G to bring across
the data from columns B:G of the first sheet. If you have more data
than this, just change the range reference from G to your last used
column.

Hope this helps.

Pete

 

[Mike H]

Steve,

How are the addresses organised? All in one cell? several cells? Where are
the initials for the address?

Mike

 

[Steve]

Hi Mike, I have first name;second name; street number; street; suburb all in
separate row cells. Can you type in a letter progressively from the first
name to find it in the list as opposed to setting up and initial column as
well?
Thanks

 

[Steve]

Thanks Pete,
That makes some sense. I'll give it a go.

 

[Pete_UK]

You're welcome, Steve.

Pete