Thread: LOOKUP VALUE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LC ANG LC ANG is offline
external usenet poster
 
Posts: 2
Default LOOKUP VALUE

Hi, I need your expert advise on my question below.

I need to lookup column say 'H' that has a wording "CASCAUT" and if true
retun result in column 'S' 'Please don't pay'. I know I can use if & vlookup
formula to return the result but column 'S' has information which I do not
want to erase.

Would appreciate your advise.

Many thanks in advance!

LC ANG