Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with dificult formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with dificult formula
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with dificult formula
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 | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|