Hi,

Your vlookup formula could look like this
=VLOOKUP(D13,Sheet1!A9:C10,MATCH(D13,{"PM","Asst"} ,0)+1,FALSE)

You can add more items to the Match function but keep them in order by
column you want to return.

--
Thanks,
Shane Devenshire


"KalliKay" wrote:

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