Vlookup for value

S

Stephen

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!
 
P

PCLIVE

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference Cell in VLOOKUP 5
VBA code adds unwanted characters 2
VLOOKUP VALUE ERROR 5
VLookup error - Sub or function not defined 4
VBA Formula 2
Vlookup error 1
vlookup issue 2
Vlookup issue? 8

Top