Thread: compare two columns with different ranges in two worksheets
View Single Post
  #2   Report Post  
vezerid
 
Posts: n/a
Default
In worksheet2!D1:
=if(isna(vlookup(C1, worksheet1!$A$1:$B$10, 2, 0)), "", vlookup(C1,
worksheet1!$A$1:$B$10, 2, 0))

HTH
Kostis Vezerides

Reply With QuoteReply With Quote