# Thread: Look up moving data to cell with look up. (2003)

1. ## Look up moving data to cell with look up. (2003)

Hi I have attached a document with blank cells which is called discharge date. I have a set of data that needs to be moved into the discharge cells, matched by the Ni number.

I have listed instructions on the xls.

If you could help that would be great.

Thank you so much

2. ## Re: Look up moving data to cell with look up. (2003)

Welcome to Woody's Lounge!

Enter this formula in F2:
<code>
=IF(ISNA(VLOOKUP(D2,\$H\$2:\$I\$231,2,FALSE)),"",VLOOK UP(D2,\$H\$2:\$I\$231,2,FALSE))
</code>
and fill down as far as needed (for example by double clicking the fill handle in the lower right corner of F2).

The essential part of the formula is
<code>
VLOOKUP(D2,\$H\$2:\$I\$231,2,FALSE))
</code>
This looks up the value of D2 in column H, and returns the corresponding value from column I. The rest of the formula is intended to suppress the #N/A value if the Ni number is not found.

3. ## Re: Look up moving data to cell with look up. (2003)

Hi hans I still need help please. All the discharge dates on the right hand side (I Column) of the spreadsheet need to be put into the empty discharge date column (F) on the left of the spared sheet. The discharge date is matched with the Ni number on the right (H column) and the Ni number on the left (D column). I hope you understand, and thanks for your help.

4. ## Re: Look up moving data to cell with look up. (2003)

I have attached again the attachment with updated instructions, if you could have a look at the attachment and help/advice me that would be fantastic.

5. ## Re: Look up moving data to cell with look up. (2003)

I did try that formula, but didn't understand the out come, my previous post I have again attached the excel spreadsheet with updated instructions. I hope you can help, and again I thank you for your help/advice.

Thanks

6. ## Re: Look up moving data to cell with look up. (2003)

The attached file uses a slightly different method from Hans' but both should produce the same outcome. Note that I formatted the cells in F as dates, otherwise you will see numbers like 39156 instead of 15/3/2007.
HTH

7. ## Re: Look up moving data to cell with look up. (2003)

Thank you for your help , problem solved. Do I delete this post if problem is solved or do do I leave it on here.

Thanks again

8. ## Re: Look up moving data to cell with look up. (2003)

Rory has already pointed out the most important factor: you must format column D with a date format, otherwise you'll see numbers such as 39152. When I created the formulas, Excel applied a date format automatically, apparenly this didn't happen when you tried it.

9. ## Re: Look up moving data to cell with look up. (2003)

We leave threads in place when they have been solved - they might help someone else in the future. Many Loungers use the Search feature (in the "menu bar" at the top of the Lounge window) to see if a question has been asked before.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•