row lookup formula
 

I have a list of vendors that are associated with a job. On another
spreadsheet I have that list of vendors all with their vendor number going
from 1 and up. I need a way to display the vendor numbers on the first sheet
in the same column as the vendor and the job they are associated with. I am
trying to clean up a mess and this list is huge. Suggestions?
Ex.
Sheet 1
job vendor name (need vendor number)
security A+ Security ? - need it to bring up a 3
Catering John's Deli ? - need it to bring up a 1


Sheet 2
vendor number vendor name
1 Johns deli
2 Bobs bait
3 A+ Security

Help!

row lookup formula
 

try =index('Sheet 2'!A:A,match(B2,'Sheet 2'!B:B,0))
in C2 copy and paste down

"adam" wrote:

I have a list of vendors that are associated with a job. On another
spreadsheet I have that list of vendors all with their vendor number going
from 1 and up. I need a way to display the vendor numbers on the first sheet
in the same column as the vendor and the job they are associated with. I am
trying to clean up a mess and this list is huge. Suggestions?
Ex.
Sheet 1
job vendor name (need vendor number)
security A+ Security ? - need it to bring up a 3
Catering John's Deli ? - need it to bring up a 1


Sheet 2
vendor number vendor name
1 Johns deli
2 Bobs bait
3 A+ Security

Help!

row lookup formula
 

This may work for you.

=INDIRECT("A"&MATCH(B1,Sheet2!B$1:B$100,0))

HTH,
Paul

"adam" wrote in message
...
I have a list of vendors that are associated with a job. On another
spreadsheet I have that list of vendors all with their vendor number going
from 1 and up. I need a way to display the vendor numbers on the first
sheet
in the same column as the vendor and the job they are associated with. I
am
trying to clean up a mess and this list is huge. Suggestions?
Ex.
Sheet 1
job vendor name (need vendor number)
security A+ Security ? - need it to bring up a 3
Catering John's Deli ? - need it to bring up a 1


Sheet 2
vendor number vendor name
1 Johns deli
2 Bobs bait
3 A+ Security

Help!

row lookup formula
 

Any other suggestions?

"bj" wrote:

try =index('Sheet 2'!A:A,match(B2,'Sheet 2'!B:B,0))
in C2 copy and paste down

"adam" wrote:

I have a list of vendors that are associated with a job. On another
spreadsheet I have that list of vendors all with their vendor number going
from 1 and up. I need a way to display the vendor numbers on the first sheet
in the same column as the vendor and the job they are associated with. I am
trying to clean up a mess and this list is huge. Suggestions?
Ex.
Sheet 1
job vendor name (need vendor number)
security A+ Security ? - need it to bring up a 3
Catering John's Deli ? - need it to bring up a 1


Sheet 2
vendor number vendor name
1 Johns deli
2 Bobs bait
3 A+ Security

Help!

row lookup formula
 

any others?

"adam" wrote:

I have a list of vendors that are associated with a job. On another
spreadsheet I have that list of vendors all with their vendor number going
from 1 and up. I need a way to display the vendor numbers on the first sheet
in the same column as the vendor and the job they are associated with. I am
trying to clean up a mess and this list is huge. Suggestions?
Ex.
Sheet 1
job vendor name (need vendor number)
security A+ Security ? - need it to bring up a 3
Catering John's Deli ? - need it to bring up a 1


Sheet 2
vendor number vendor name
1 Johns deli
2 Bobs bait
3 A+ Security

Help!

row lookup formula
 

in sheet 2 copy column A to Column C
in C2 Sheet one
=vlookup(B2,"Sheet 2'!B:C,0)
copy and paste down as far as you want to go

why did you want other suggestions?
If the previous one did not give you what you need, let us know so that we
can respond with a better answer. If you just want alternatives, tell us why.

"adam" wrote:

Any other suggestions?

"bj" wrote:

try =index('Sheet 2'!A:A,match(B2,'Sheet 2'!B:B,0))
in C2 copy and paste down

"adam" wrote:

I have a list of vendors that are associated with a job. On another
spreadsheet I have that list of vendors all with their vendor number going
from 1 and up. I need a way to display the vendor numbers on the first sheet
in the same column as the vendor and the job they are associated with. I am
trying to clean up a mess and this list is huge. Suggestions?
Ex.
Sheet 1
job vendor name (need vendor number)
security A+ Security ? - need it to bring up a 3
Catering John's Deli ? - need it to bring up a 1


Sheet 2
vendor number vendor name
1 Johns deli
2 Bobs bait
3 A+ Security

Help!

row lookup formula
 

You've now been given 3 alternatives in replies to your posting, but
so far you have given no feedback to the contributors as to whether
these work for you or not - why should we give you yet more
alternatives?

Pete

On Jul 12, 9:52 pm, adam wrote:
any others?



"adam" wrote:
I have a list of vendors that are associated with a job. On another
spreadsheet I have that list of vendors all with their vendor number going
from 1 and up. I need a way to display the vendor numbers on the first sheet
in the same column as the vendor and the job they are associated with. I am
trying to clean up a mess and this list is huge. Suggestions?
Ex.
Sheet 1
job vendor name (need vendor number)
security A+ Security ? - need it to bring up a 3
Catering John's Deli ? - need it to bring up a 1

Sheet 2
vendor number vendor name
1 Johns deli
2 Bobs bait
3 A+ Security

Help!- Hide quoted text -

- Show quoted text -

row lookup formula
 

Sorry very busy, thanks very much for you contributions, it did help. I had
my head stuck up my, you know what and didn't notice on the first that they
were ref row 2 and mine was starting off with row 1. My bad! Thanks for the
help.

"Pete_UK" wrote:

You've now been given 3 alternatives in replies to your posting, but
so far you have given no feedback to the contributors as to whether
these work for you or not - why should we give you yet more
alternatives?

Pete

On Jul 12, 9:52 pm, adam wrote:
any others?



"adam" wrote:
I have a list of vendors that are associated with a job. On another
spreadsheet I have that list of vendors all with their vendor number going
from 1 and up. I need a way to display the vendor numbers on the first sheet
in the same column as the vendor and the job they are associated with. I am
trying to clean up a mess and this list is huge. Suggestions?
Ex.
Sheet 1
job vendor name (need vendor number)
security A+ Security ? - need it to bring up a 3
Catering John's Deli ? - need it to bring up a 1

Sheet 2
vendor number vendor name
1 Johns deli
2 Bobs bait
3 A+ Security

Help!- Hide quoted text -

- Show quoted text -