help with dificult formula

[cjbarron5]

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

 

[cjbarron5]

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!!!!!!!!!!

 

[Niek Otten]

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

|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
| >
| >