Excel Excel VLookUp

[dchill]

Trying to seach for a word from one worksheet within a particular column, and if found, paste the word from a cell within the worksheet the word was found in, on another worksheet, within the same workbook and repeat this for all the adjacent cells.

 

[Rook]

So you know you need a Vlookup function right?..
I can help you with the function if that's what you meant, but I'm not sure I understood you...

 

[alow]

If you're looking for a full VLOOKUP explanation, I have one in a previous post here.

 

[sallean]

I know I need to use VLOOKUP for the following:

Fill in Vendor Name, City, State and Customer Service email for all vendor numbers with the help of VLOOKUP


I am stuck. Vendor# is column A. Column B, C, D, and E are the blanks that need filled out respectively.
Thanks, Sallean
​