F
ForSale
Hello,
On sheet2 I have a list of names, ID numbers and supervisors. For
example:
_|B___|___C___|___D|_
_|Bob___|___15___|___Tom|_
On sheet1 I have a similar setup. The user will input an ID number on
sheet1, sheet2 is purely for archive. I am trying to achieve a formula
on sheet1 that will put in the name and supervisor of an agent when the
user puts in an ID number on sheet1.
For example: Bob #15 is archived on sheet2 and his supervisor is Tom.
When the user puts in 15 in sheet1(“c12”) I want b12 to show his name
and d12 to show his supervisor.
Thanks in advance,
On sheet2 I have a list of names, ID numbers and supervisors. For
example:
_|B___|___C___|___D|_
_|Bob___|___15___|___Tom|_
On sheet1 I have a similar setup. The user will input an ID number on
sheet1, sheet2 is purely for archive. I am trying to achieve a formula
on sheet1 that will put in the name and supervisor of an agent when the
user puts in an ID number on sheet1.
For example: Bob #15 is archived on sheet2 and his supervisor is Tom.
When the user puts in 15 in sheet1(“c12”) I want b12 to show his name
and d12 to show his supervisor.
Thanks in advance,