Thread: lookup help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curtis Curtis is offline
external usenet poster
 
Posts: 181
Default lookup help

I need a formula in row E (e2:e500) that will look in range c2:c500 for a
value equal to that in range d2:d500.

ex:If there is a value in column c that matches that in column d I want
column e to say "OK". If not to show the value in column d

thanks