Try VLOOKUP() instead.
Look here for a tutorial:

http://www.contextures.com/xlFunctions02.html

Or post a much clearer description of your worksheet and what you're trying to achieve

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cjbarron5" wrote in message ...
|I have tryed the =if function and it works as long as it is pointed at one
| cell but I need to look thru a range of cells HELP!!!!!!!!!!
|
| "cjbarron5" wrote:
|
| ok I have a job tracking sheet that I want to be able to take info from and
| autofill info on my invoice sheet by entering just the job# off of the
| tracking sheet Im not sure which formula to use and how to format the formula
| any Ideas
|
|