Hi

Im making a formula which is to return the a "Reasearch Factor"
depending on the "Cost".

One sheet contains a table of data whe Costs between "Cost From" and
"Cost To" Gives the a certain "Research Factor".

On another sheet I made this fomula which is trying to pull out the
"Research Factor" depending on the job cost.

This is the fomula Im using:

=IF(D6'Research Factor'!$A$2&D6<'Research Factor'!$B$2, 'Research
Factor'!$C$2, (IF(D6'Research Factor'!$A$3&D6<'Research
Factor'!$B$3,'Research Factor'!$C$3)))

However it seams that I can't use the "&"..


What am I doing wrong?


--
Ctech
------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=499707