Foruma to query 1 column then copy the next column across and paste to a new column

hi,

I have an excel spreadsheet with 2 sheets. On one sheet i have a list of usernames down one column then on the next 2 columns i have the users first and last name respectively.

On the second sheet i have a column with the same usernames (they are not in the sameorder as the first sheet) and then the next column has a list of laptops assigned to the users (1 laptop each). The laptops have to be reimaged and renamed and are getting done in lots at a time. There is a third column setup that currently stays blank until the laptop has been renamed then the new name is placed there.

What i need is a formula in the next column across that displays the first name (and then the next column to show their last name) of the users whose laptops have not yet had their laptops reimaged/renamed. At the moment i have the column as:

=IF(D2="",A2,"")

D2 being the column with the renamed laptops and A2 being the username of the user. So all it shows at the moment is the username and i need it showing users name instead.

Please help!!!

Hi and welcome to the forum

We would love to help you with your question, but 1st, in accordance with forum rules, please rename your thread to something more meaningful, that actually describes your problem.

Because thread titles are used in searching the forum it is vital they be written to accurately describe your thread content or overall objective using ONLY search friendly key words. That is, your title used as search terms would return relevant results.

Many members will look at a thread title, and if it is of interest to them, or it falls within their area of expertise, they might only open those threads.

Look at it this way...if you typed that title into google, what would you expect to get back?
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title