create a link

[GeorgeTriton]

In the attached spreadheet I can find an Item by either the pull down tab or by entering it in the a2 cell, what I have is multiple items in the same location so I must compare the Item # and Location and then have this item line appear. When I enter the Loc #, I always end up at the 1st Item in the numeric-alpha sequence. How do get around this?

[keithl816]

Try using vlookup

Place this in cell B3

=VLOOKUP($A1,$A$5:$E$369,5,FALSE)

This would bring up your location based on what item you choose in the dropdown.

Hope this helps

[GeorgeTriton]

Works great, I'm new at this and am struggling. I have lots of ideas on how to refine this spreadsheet but also have a lot of reading and learning to do 1st. Your help is GREATLY appreciated.

George