Formula in XL

  Big Bear 07:58 30 Sep 04

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 04

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 04

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now