Please help with a macro using VLOOKUP

[everydayiwakeup]

Hey guys,

I am in serious need of help with a macro for work. So I made this test file with the exact rows I'm dealing with on sheets 2 and 4 of a different file. What I need to do is use the A columns on the sheet as a key with Vlookup (actually it doesnt have to be VLookup) and then compare the sheet 2 F column and sheet 4 I column and then make the cells that have the same value in A but different values in F/I to appear yellow in sheet 4's I. If that wasnt a good explanation please let me know and I can elaborate.

I would really appreciate help on this. Thanks.

[Glenn Kennedy]

The easiest way to do this is using Conditional Formatting, using this formula:

=I1<>VLOOKUP(A1,Sheet2!$A$1:$F$20,6,FALSE)

See sheet.

[everydayiwakeup]

Hi Glen,

Thanks this seems to work, but I have a couple questions. I need it to select all of the cells in the column as apposed to just until "I20" because the orginal file has around 7k cells. Even though it might bot be effective I kind of want it in VBA because I am adding on to a macro that is going to be used again later for big files. Do you think I could just do this with the macro recorder on and then use the macro it makes for me? Thanks and sorry for being new haha.

[Glenn Kennedy]

You could just adjust the ranges to cover what you need, plus a bit more to make it "future-proof". CF is pretty quick. Keep the thread open if you want a VBA solution (i'm hopeless with it!!). Bump it if there's no reply within a "reasonable" period.

[bakerman2]

Let's start with this.

Please Login or Register  to view this content.

[everydayiwakeup]

Works like a charm bakerman. Thank you!

[bakerman2]

You're welcome and thanks for rep+.
If this takes care of your question please mark the thread as Solved.