I am trusting on the best of minds in VBA to assist on this problem!!!


OK! I have account numbers in column "A" that I need to compare with similar account numbers in column "B".

Once I locate a match I need to program the spreadsheet to grab the ID number in column "C" that are associated with the account numbers in col. "B"!

HAVE I CONFUSED YOU YET!!

Now I attempted, with no success, to loop through the range of cells in col. "A", and look for a match in col. "B". If rngACell.value = rngBCell.value then perform a VLookUp for the ID # in col. "C".

I am confident that someone has come across this problem before, or it may not even be a problem....I must be getting close to the solution...

Thank you in advance..