Data pick up -dynamic

[srini_tbcl]

Dear Friends,

Enclosing herewith a spread sheet (Record Insert) with 2 sheets.
MASTER
WORK

I am using vlookup individually for every row.

Pl help me for a Macro:

Master data is available in MASTER Sheet
Emp ID is keyed in Column B
Other column values of WORK have to be picked-up from master.

CONDITIONS:
In case of repetition value of EMP ID (B column) error message
If EMP Id does n't exist in MASTER- Error Message.

Regards

Srinivas

[oeldere]

work!I4=countif($B$4:$B$18,B4)

Master!I3=if(VLookup(A3,WORK!$B$3:$I$18,8,0)>1,"error",VLookup(A3,WORK!$B$3:$I$18,8,0))

Notice => your example don't provide all criteria to check the formula.

[srini_tbcl]

Dear Friend
Thank you very much for reply.

Criteria:

Any Cell in Column B is INPUT. After keying in value

1. It should be checked thro' column B for existence. If exists.. Message "Already Exists"
2. It should be checked in "MASTER" sheet. If exists the corresponding values should be picked up and to be displayed in "Work" sheet ELSE Message " Record not found in MASTER"

Regards

Srinivas

[oeldere]

Did you tried my solution?

If so, did it work for you.

[srini_tbcl]

Thank you very much for your reply.

But, my requirement is a macro which fulfill the criteria I mentioned.
Entire range above the Work column must be taken for input verification. Similarly, Entire Master Sheet range should be selected.

Regards

Srinivas

[oeldere]

That is not an anwer to my question.

Please answer if the solutions works.

If so, you can record this manual actions, with the macro recorder and you have the VBA code.