Thread: Vlookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Vlookup

Hi,

in C1 enter

=IF(SUMPRODUCT(--(B1=$A$1:$A$2000))0,"True","False")

copy formula down

"Katerinia" wrote:

COL of codes in A (full List of codes of about 2,000)
COL of codes in B (selection of COL A codes of about 850)

IF COL B code matches COLUMN A code, then true, else false