Matching values between two ranges

[hood8jmark]

Hi all,

I need help matching values between two ranges. I can't seem to figure out how to utilize VLOOKUP, FIND, or MATCH to suit my needs. With the following code I have set my search range to a list. I simply took a range in Sheet2 and converted it to a list which probably isn't necessary. At any rate, I now need to be able to search CloumnC in Sheet1 for matching values in this list and when found, populate the corresponding cell (in the same row of the found value) in ColumnE on Sheet1 with a value of "Late". The code below identifies the search range and converts it to a list. How do I implement VLOOKUP, MATCH or FIND or any other method for that matter to accomplish this.

Please Login or Register  to view this content.

[rylo]

Hi

Can you please review the forum rules about wrapping code. I've edited your post this time, but please remember to wrap your code in future.

For a solution, try this

Please Login or Register  to view this content.

rylo