Dear Mike,

It is possible by using Reference formulas such as VLookup and IndexMatch,
provided that it is organised systematically and consistency.

Maybe you would like to provided a detailed aspect of what you are trying to
do.


My Question:

1) In Sheet 1 is 1 column worth of names?
Jane Doe
John Doe
McDowell

Yes / No?

Is there a code or some reference number attached to the name?
Example:
----A------------B
1234------------Jane Doe
1235------------John Doe
1236------------McDowell

Yes or no?

2) In Sheet 2
1234 Usernameneedstogohere 1234

1234 is a number or code or Name in sheet 1?


3) In Sheet 3
1234 name1 1234

This is in 1 column . Information you require is:

from sheet 2 & from sheet 1 & from sheet 2?

<IJWTK
Quill666