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)

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)

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)

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 -

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 -

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 -

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


"Pete_UK" wrote:

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 -

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

On Nov 14, 3:27 pm, GOODCREATIONS
wrote:
Hijacked? what does this mean?
Should I be worried?



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

- Show quoted text -

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

"Pete_UK" wrote:

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

On Nov 14, 3:27 pm, GOODCREATIONS
wrote:
Hijacked? what does this mean?
Should I be worried?



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

- Show quoted text -

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

Pete

On Nov 14, 4:22 pm, GOODCREATIONS
wrote:
oh o.k L.O.L
Thanks again. :)



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

On Nov 14, 3:27 pm, GOODCREATIONS
wrote:
Hijacked? what does this mean?
Should I be worried?

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

- Show quoted text -- Hide quoted text -

- Show quoted text -