Formatting Excel between worksheets & Automatically Populating

Hi All!

I'm stuck trying to populate the information from one sheet to another.

Basically, I am wanting the two worksheet to reflect the same information (but it will be displayed differently which is why I need the two), for example:

SHEET #1:
COLUMN A-------------------COLUMN B
John Smith----------------{Need to add number}

SHEET #2:
COLUMN A--------------------COLUMN B
{Need to add name}------------123

So when the number is entered into "Sheet 1/Column B" and equals the number on "Sheet 2/Column B", I am wanting the name from "Sheet 1/Column A" to automatically populate in "Sheet 2/Column A"

Hope that makes sense that that someone can help!!!!!!

Hi,

In Sheet2 where you want the name:

=OFFSET(Sheet1!$B$1,MATCH(B2,Sheet1!$B$2:$B$10,0),-1)

HTH

Steve

Formatting.xls

Unfortunately I can't get that formula to work - I'm sure that it's a user error on my behalf!!