Hopefully easy question

Hi all,

I am looking for some help. I am inputting data on a basic excel spread sheet. On sheet one is the form i am filling in,
On sheet 2 is 2 colums, one with staff id numbers anf the second with names.

To stop me constantly having to check the second sheet and manually inputting the staffs name, i want to be able to put the staff number into the first sheet and it automatically change to the Staff members name.

Is it possible to do this were a formula checks for the staff id when inputted (sheet 1), finds it on sheet 2 (column A) then replaces it with staff name (column B sheet 2)

Thanks for any help in advance.

Paul

i think you can do that using macro.

Just an idea

try this one.

put the formula in a dummy cell you can use lookup in cell (O1)
then run the macro to overwrite the data entered ( id )
O1 - dummy cell ( formula)
A1 - data entry ( id )
enter first a value then run the macro

Sub Macro()
    Range("O1").Select
    Selection.Copy
    Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
End Sub

Hope this will start some reply on your thread.