View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ronald Cayne Ronald Cayne is offline
external usenet poster
 
Posts: 12
Default VLOOKUP Is NOT CORRECT

Please help me fill in the ???? Offset Command ??


LIST= Sheet 2 Column 1
BLOCK=Sheet 2 A1:G1000
A1 is on Sheet 1
Formula is placed on Sheet 1 B1

Vlookup can't be used as duplicate entries may exist in BLOCK column 1

=IF(ISERROR(LOOKUP(A1,list)),"new",???)