I am working on a new table to simplify things.
I have right now worksheet that has the following column headings and data
User Input CROSSWALK ITEM # ITEM Description
TRAIN 010 CAR
CARR 020 TRAIN
HOOUSE 030 GARAGE
Garage 040 HOUSE
I want to create a macro OR some type of look up that will
#1 examine [User Input] - in column A
#2 find what is similar in [ITEM Description] - in column D
#3 put the [ITEM #] in column C into [CROSSWALK] - column B
Can anyone give me assistance on this? I tried V & H lookups however because sometimes the [User Input] does NOT match as in my example nothing will work. Can not think of another solution... Any ideas?
Much advanced thanks.
Steve
Bookmarks