| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Lookups
Hi
Was wondering if it is possible to use a lookup or other tool for the following scenario: A column on a sheet contains a list of unique references in the format AA111111 A 2nd sheet also contains a list of unique references in the same format, some of which may match a reference on the 1st sheet. Is it possible to use a lookup to compare the columns on the 1st and 2nd sheet, and highlight any matches on the 2nd sheet? Thanks Andy |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
Lookups
Use COUNTIF
=IF(COUNTIF(Sheet1!A:A,A1)0),"Matched","") -- HTH RP (remove nothere from the email address if mailing direct) "Andy" wrote in message o.uk... Hi Was wondering if it is possible to use a lookup or other tool for the following scenario: A column on a sheet contains a list of unique references in the format AA111111 A 2nd sheet also contains a list of unique references in the same format, some of which may match a reference on the 1st sheet. Is it possible to use a lookup to compare the columns on the 1st and 2nd sheet, and highlight any matches on the 2nd sheet? Thanks Andy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookups | Excel Discussion (Misc queries) | |||
| Lookups??? | Excel Worksheet Functions | |||
| Lookups | Excel Discussion (Misc queries) | |||
| Lookups | Excel Worksheet Functions | |||
| LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions | |||
Linear Mode
