Hi Folks,

I'm trying to use a Vlookup in one sheet to return the value from another
sheet (if it exists) but my lookup_value cell contains a formula. Is there a
way i can tell the Vlookup to ignore the formula and focus on the value of
that formula.

Example

Col A Row 6 =VLOOKUP(B6,EmployeeNumbers,2,FALSE)
* the value is 0622

My Vlookup in Col D Row 6 =IF(ISNA(VLOOKUP(A6,'NJ Union Contract Raise
Report'!A1:F300,6,FALSE)),"",VLOOKUP(A6,'NJ Union
Contract Raise Report'!A1:F300,6,FALSE))
*How can I tell this to use the value from A6 which is 0622??

Any help is always greatly appreciated.

TIA!