formula question

[Guest]

Hello everyone!
I am a newbie here and this is my 1st question.
I am trying to get this formula going, and I can't figure it our for the
life of me.


A B C D R S
$20.00 4 1
JOB 1
2
JOB 2
3
JOB 3

If I plug a # like 1,2, or 3 according to row R in row A, then job 1, job
2, or job 3 pop up on row "B" depending on the number I plug into row "A".
I hope this makes sense :O)

 

[Pete_UK]

I think you are getting your rows and columns mixed up.

Do you mean that you want to put a number, n, into column A, and for
"JOB n" to show in the corresponding cell of column B? If so, then try
this in B1:

=IF(A1="","","JOB "&A1)

Copy this down for as many rows as you require.

I'm not sure where columns R and S come into this, though.

Hope this helps.

Pete

 

[Guest]

I'm sorry my table got dissaligned. column R is the number which is assigned
to each job on the right side (column "S") This is my set table
what I wanted to do was just plug in a number from column "R" into column "A"
and the job corresponding to that number in column "S" would pop up in column
"B" (instead of having to type the entire job description each time it would
pop up in
column "B" after I type just one number

A B C R S
1 CUT LAWN
2 WASHED CAR



So if I plugged in # 2 in cell A1 I would get "washed car" automatically in b1

Thanks so much for your quick response.

 

[Pete_UK]

In that case, try this:

=IF(A1="","",VLOOKUP(A1,R$1:S$10,2,0))

and copy down as required.

I've assumed you have up to 10 jobs defined - adjust the range
references if necessary.

Hope this helps.

Pete

 

[Guest]

Wow Pete,
Thank you so much! It worked like a charm. That was really nice of you.
Thanks again.

 

[Pete_UK]

You're welcome. Looks like your thread got hijacked in the middle.

Pete

 

[Guest]

Hijacked? what does this mean?
Should I be worried?

 

[Pete_UK]

No, no.

Somebody else asked a question in your thread, rather than starting a
new one. His post was then answered by other people, so the list of
postings looks a bit messy, because you then came back to reply to the
earlier branch.

Nothing to worry about - it's better to keep the postings within the
one thread, that's all.

Pete

 

[Guest]

oh o.k L.O.L
Thanks again.

No, no.

Somebody else asked a question in your thread, rather than starting a
new one. His post was then answered by other people, so the list of
postings looks a bit messy, because you then came back to reply to the
earlier branch.

Nothing to worry about - it's better to keep the postings within the
one thread, that's all.

Pete

 

[Pete_UK]

That's quite allright - sorry if I "spooked" you!

Pete