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

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

I need to look up one column say 'H' with wording "Cas" and if true column
'S' will populate "Please pay up". I know I can use "ifvlookup" formula to
perform this task but colum S itself has comments which I do not want to
overide by the formula code.

Would appreciate your advise on this.

Example

Column H Column S
Cas Please pay up
TT