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