IF formula, etc.??

  • Thread starter Thread starter BruceM
  • Start date Start date
B

BruceM

I need to try and create an "if" formula that will look at
a cell for a numeric entry and if there is one copy the
name of that job to a shipping schedule on another page.
For example:

cell A1 is the job name. cell B1 is the number of units
for the job. the number of units is carried through a
weekly schedule culminating in the job completion as noted
with the number of units calculated to appear in cell M1.
When the number of units arrives in cell M1 I need the job
name to appear in cell N31 which is the shipping
schedule. Is it possible to query a cell for a numeric
entry (M1) and if it has one go back to its row origin (A1)
to find the text name and copy elsewhere (N31)?

Thx for any help!
Bruce
 
jr, thx for your response. when i type in =IF(ISNUMBER
(A8),"number", "not number") i get Not number. what i
want is the job name that is in cell A8 to show up on
another page/cell, but also from "referencing another cell
further across in row 8 (e.g., M8) that will have a number
as the data vs text. in other words when a number "hits"
cell M8, i need to plug in a formula in cell k31 that will
recognize the number occuring in cell M8, but track back
to the row origin (cell A8) and copy the job name from A8
to K31.

i know this is confusing, but i hope you can better
understand the need now and be able to direct me further.

Thx MUCH!! Bruce
 
Back
Top