View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Oscar Kelley - Salmon Days Festival
 
Posts: n/a
Default look up a value in one column to another colum

I am trying to check it a item is new. Comparing two columns (900-1500 records)

I using IF(ISNA(LOOKUP(A2,G$2:g$1474)),"","Match")

But match is not being returned for any records
sample of data

Isomedia MAC# Unit ServiceStart Match Div_Lot RegNumber MAC
1023201471 050-0026 1/20/04 050-0026 1023201471 0002A11B2730
1037653266 025-016R 5/25/04 025-016R 1037653266 0002A1188B60
1045954143 0002A11BC470 007-0019 6/11/04 007-0019 1045954143 0002A11BC470
1048849824 0002A119D1F0 051-0004 12/8/04 051-0004 1048849824 0002A119D1F0
1055082119 025-091R 6/9/04 025-091R 1055082119 0002A1192DA0



--
Oscar Kelley
HFN Data Analyst
Highlands Fiber Network