D
David Knapp
I have a two worksheets, called items and clients. The
first has a list of purchased items and the second is a
list of client numbers and addresses. The linking field
is the item number, which exists in both worksheets. I
would like to add a column to worksheet one (items) that
would display the client number from worksheet two
(clients) for the particular item number. If the client
number from worksheet two is missing, I would like
worksheet one to just display a blank in the client column
for that row. Could someone point me in the proper
direction on how I do this? It seems like sort of a
database sort of question, but that is not an area in
Excel that I am familiar with. Thanks for any suggestions.
first has a list of purchased items and the second is a
list of client numbers and addresses. The linking field
is the item number, which exists in both worksheets. I
would like to add a column to worksheet one (items) that
would display the client number from worksheet two
(clients) for the particular item number. If the client
number from worksheet two is missing, I would like
worksheet one to just display a blank in the client column
for that row. Could someone point me in the proper
direction on how I do this? It seems like sort of a
database sort of question, but that is not an area in
Excel that I am familiar with. Thanks for any suggestions.