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

Pete

On Nov 14, 7:22 am, GOODCREATIONS
wrote:
Wow Pete,
Thank you so much! It worked like a charm. That was really nice of you.
Thanks again.



"Pete_UK" wrote:
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

On Nov 12, 11:17 pm, GOODCREATIONS
wrote:
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" wrote:
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

On Nov 12, 9:30 pm, GOODCREATIONS
wrote:
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)- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -