Thread: syntax question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Giselle
 
Posts: n/a
Default syntax question

Hi XLers

This code fragment works well, resulting in a cell value of, for example,
Teacher

Worksheets("PrintRpt").Range("C1").Formula =
"=INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0)) "


But, I want the cell value to be Job Title: Teacher

I know this should be simple, but I can't get the syntax to work?

TQ for any help
Giselle