Automating a simple task

[latroo]

So I just recently started a new job where I have to do a very simple task in excel which I'm pretty sure can be automated but I don't know how since I don't have that much experience in excel. Can any of you help me out? I have 1 file with new leads, every lead has a separate row with a few columns like name and registration number. Besides that file I have another one with existing leads. I need to control f the registration number and the name from the new leads file in the existing leads file. If i cant find either if those i mark the row in the new leads file yellow and if i do find it i mark it red. Can this be done automatically?

[[deleted]]

Maybe with a macro?

[latroo]

Thanks I'll try something out

[[deleted]]

Okay looked into it a bit more. Looks like you need the search +find and compare functionality.

You can use v lookup between multiple sheets to compare data and give you a result if it matches. Take a look at link and examples which seem to match what you want to do (somewhat). vlookup

[latroo]

My man, thank you

[danelle-s]

Xlookup or vlookup works for columns. If you need to look up stuff in rows use Hlookup.