Compare and copy corresponding data issue...

[crisnnik]

New to the forums, and based on my searching, I am sure someone in here can help me out. I am trying to find a way to compare each cell in a column to all of the values in a different column, and if an exact match is found, it copies the corresponding value from a different column over...

In the attached sample, I would like each cell in Column A to be checked for a match ANYWHERE in COLUMN F. If it finds a match, it copies the corresponding value from COLUMN I to the cell in COLUMN D (red data in sample - manually entered to show desired result).


Thanks in advance to anyone who can help me out with this!! I tried utilizing the MATCH function, but couldn't figure out the syntax properly.


-crisnnik

[arlu1201]

Its better if you attach a sample excel file than a jpg.

[Ricker090]

You can try a VLookUp function.

Copy and paste the following formula into cell D2 and down.

Please Login or Register  to view this content.

[crisnnik]

You can try a VLookUp function.

Copy and paste the following formula into cell D2 and down.

Please Login or Register  to view this content.

Superb! Worked like a champ... Than you very much!!