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!

VLOOKUP does in fact look at the value and Not the formula. If you are not
getting the desired result, then there must be some other reason. What are
you getting from your VLOOKUP formula? Are you getting #N/A? If that is
the case, then chances are that VLOOKUP is not finding the A6 value within
your table. Possibly your table contains test and your A6 value is a
number. First, test cell A6 to see if it is a number:
=ISNUMBER(A1)

Then, manuallyl find the 0622 value in your lookup table and perform the
same test on that cell. Change A1 to whatever the cell is.
You could also test the cells agains each other. Assuming 0622 is in cell
A5:

=A1='NJ Union Contract Raise Report'!A5

If that comes back false, then that's the problem.

HTH,
Paul


--

"Stephen" wrote in message
...
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!