Hi all,
I am attempting to pull in a field value into my worksheet and am having
difficulty - I am using lookup but can't seem to figure this out!
=========================================
I have 2 worksheets:

--Worksheet 1 contains:
Column A = Data Field Names

--Worksheet 2 contains
Column A = Data Field Names
Column B = <blank or 'P1'

I want to "lookup" the Data Field Name on Worksheet 2, and if it has a
status code of "P1" in column B, I want that status to go into Column B on
Worksheet 1 on the same row of the Data Field Name:

example:
Worksheet 1 have the following:

Data_Field_1
Data_Field_2

Worksheet 2 has the following:
Column A Column B
Data_Field_1 P1 ***want this value to appear in
worksheet 1
Data_Field_2