auto populate cells

[electriceaze]

I have a workbook with three (3) worksheets which i will simply call worksheet #1, #2 and #3.
In worksheet #1, I enter data into these columns- date, po#, account name, rep, so#, amount. In worksheet #2, once I enter a so# into a cell I would like the corresponding account name to auto populate into the following cell, using worksheet #1 as the reference.
Data is entered into this workbook daily so my reference data will continue to expand.
Is there a function I can use or will i have to create a macro?

 

[Mister_T]

As your Account name is before SO, cant do a straight forward Vlookup,
Quickest way, is in a new sheet ref a1 to look at first cell in column contaiing SO in sheet 1, then B1 = first cell in column Account name in first sheet
Highlight these tqo columns and set as range say Account_Name

Then in your second sheet in Account name enter frmula
=vlookup(c2,Account_Name,2,0) changing c2 to cell you are populating with SO

Hope makes sense