On Worksheet 2 I am pulling data from a data base to create the bar code
sheet from on Worksheet 1.

Worksheet 2 Data
Column A Column B Column C
Property PM Approver Asst Approver

row 3 AA AA_PM AA_Asst
row 4 BB BB_PM BB_Asst
row 5 CC CC_PM CC_Asst

range=Property range=PM_Approver range=Asst_Approver

Worksheet 1 (Bar Code Sheet)

Cell B7 is selected from a range called "property" on WS2 (A3:A5). Cell A12
is selected from a hardcoded DDL of "PM" or "Asst."

If value in A12 = "PM", I need to lookup up the PM_Approver (WS2colB)
associated with the property in WS2colA and the same to hold true for
Asst_Approver in WS2colC in A12 = "Asst".

Any assistance would be appreciated. Thanks so much.

KK