Formula in XL

  Big Bear 07:58 30 Sep 2004

Can any one help please?
Is there a formula to check a list of values in one column with a list of values in another column and to hilite or mark those that match.
Thank you
Big bear

  stlucia 08:45 30 Sep 2004

VLOOKUP and HLOOKUP functions allow you to search ranges of data for a match. I haven't used them in a long while, so can't give you step-by-step instructions, but maybe someone else can. You may have to combine them with an IF statement so that you end up with a simple "Y" or "1" or whatever you want to signify a match was found.

  VoG II 09:59 30 Sep 2004

A bit more explanation needed. A match for any value in another column or the same row in another column?

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

HTC U12 Plus review: Hands-on

See how VFX studio Rise created 'Jabariland', holograms & digital doubles in Marvel Studios' Black…

Best Android emulators for Mac

Comment importer des contacts d’un iPhone à un autre iPhone ?