View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Linking Cells...

VLOOKUP will perform the correlation of text to numbers. When you say
"check the delivery column", do you have a checkbox in that column?
Assuming you do, you might use and IF statement, something along the
lines of =IF(D1=TRUE,5,0).