row lookup formula

[Guest]

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!

 

[Guest]

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

 

[PCLIVE]

This may work for you.

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

HTH,
Paul

 

[Guest]

Any other suggestions?

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

 

[Guest]

any others?

 

[Guest]

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.

 

[Pete_UK]

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

 

[Guest]

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.