Compare values from differnt worksheets and write in adjacent cells

[Mingerso]

Hello!

I am new to programming in excel but am looking to make a VBA that allows me to see if a value entered exists in a second spread sheet. If it does then write a comment next to it. If not then write a different comment.

This is what my spread sheet currently looks like:
Sheet1 contains all the important information:

A	B	C	D	E	F
Load	PO	Delivery	Email	Item	ShipCon
1	3456	6543	Y	5219
				5129
2	2345	5432	Y	1234
				4321

<tbody>
</tbody>

Sheet2 contains the items that contain a shipping condition. There are two shipping conditions Fragile and non-Fragile. The list is of Fragile items.

Item

5219

1234

<tbody>
</tbody>

I am looking for a way to have it set up that when i enter an item number in sheet in 1 it searches in sheet 2 to see if it is fragile, if it is then returns, in sheet 1 column F next to that specific item 'Fragile'. If it doesn't find it in the list returns 'non-fragile'

Any tips or pointers would be awesome!!!!

 

[patel45]

a link to a sample file with data and desired result would be helpful

 

[Mingerso]

Okay so when i start i copy everything into the build sheet and text-to-column it into proper place. I can get everything from the copy and paste except the comment column. I was wondering if there was a way to have that populate through searching the second sheet as an array.

https://docs.google.com/file/d/0B2w8qk6xLSgzcC1rVjFMdmREMjg/edit?usp=sharing

 

[Mingerso]

Figured you a solution using VLOOKUP! Thanks!

 

[patel45]

see attached
Wikisend: free file sharing service Build Sheet.xlsx