Should say if returns false does column 3.

H

"L. Howard Kittle" wrote in message
. ..
Hmmm, I might be missing something here. The formula I posted says if
TRUE do column 2, if FALSE do column 3.

The C2 values have to have some method of cooperation, like every number
below a certain value is an employee. So if the formula returns False it
does column 2.

Regards,
Howard

"Tomkat743" wrote in message
...
=INDEX(Sheet1!$A$1:$C$44,MATCH(I2,Sheet1!$A$1:$A$4 4,0),2)
=INDEX(Sheet1!$A$1:$C$44,MATCH(I2,Sheet1!$A$1:$A$4 4,0),3)

How can I dynamically choose which column ie;2 or 3 this formula returns
data from based on the assigned installer in CELL C2?

The possible installers in column C would range from 9501 to 9599 some
installers are employees and would need to pull from column 2 and other
installers are contractors and would need to pull from column 3.