Track number from a list and copy paste the value's

[nicod]

Hi Guys!

Excel is giving me a hard time. I hope you guys could help me find a solution.

I have a grocery list like in the picture below in Worksheet1. The one below is simplified but actually it exists out of 1000 numbers with different discription, units and amounts. The worksheet1 one imported does not change anymore.

[IM


In Worksheet2 I have an empty list like below.

[/URL]

What I would like to do is, when I fill in a number in Worksheet2 it automatically looks up if it exists in Worksheet1. If it exists it should copy and paste the cell value that is in the same row in colum B(description), C(unit) en D(amount).

For example : The number is filled in, the green hatches are automatically copy pasted from the list in Worksheet1.

[/URL]
image uploader
[/IMG]

I hope I have made myself clear enough. If you have any questions leave a message. Thanks in advance guys!

Kind Regards,

Nico

 

[philwojo]

On Sheet2 try these:

In Cell B2

=IF($A2="","",IF(ISERROR(VLOOKUP($A2,Sheet1!$A$2:$D$14,2,0)),"Bad",VLOOKUP($A2,Sheet1!$A$2:$D$14,2,0)))

In Cell C2

=IF($A2="","",IF(ISERROR(VLOOKUP($A2,Sheet1!$A$2:$D$14,3,0)),"Bad",VLOOKUP($A2,Sheet1!$A$2:$D$14,3,0)))

In Cell D2

=IF($A2="","",IF(ISERROR(VLOOKUP($A2,Sheet1!$A$2:$D$14,4,0)),"Bad",VLOOKUP($A2,Sheet1!$A$2:$D$14,4,0)))

Change the word "Bad" to whatever you want if the number you input in column-A isn't valid.

Copy down the B2, C2 and D2 cells as far as you want. Update the $d$14 value to grow as big as your list on Sheet-1.

 

[nicod]

Hi philwojo,

This is exactly what I mean. Thank you so much!

This thread can me closed.

Kind Regards,

Nico

 

[philwojo]

Glad to help.