Excel still not recognising equal values

P

pecan

I have a list of users with unique ID numbers, and I've used vlookup to get
some more information about them on to one worksheet (sheet 1).

I now want to use vlookup again to get some information about a few of the
users on to another worksheet (sheet 2). The problem I'm having is that
Excel is not recognising the equal values between sheet 2 and sheet 1. I've
gone into the cells in sheet 1 to see if there is a rogue space somewhere
messing me up, and there isn't, but as soon as I hit return then the vlookup
on sheet 2 starts working. This has the unfortunate side effect of messing
up the vlookup that gets the information into sheet 1 in the first place!

I've tried paste special to make both columns values only, but it hasn't
worked.

I can't figure out why clicking on the cell and hitting return would get the
formula to work.

Any ideas?
 
N

Niek Otten

Always post your formulas and the values of the arguments.

<I hit return>
In which cell?

<messing up the vlookup that gets the information into sheet 1>
What does that mean?

Are all cells either text ot numbers?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a list of users with unique ID numbers, and I've used vlookup to get
| some more information about them on to one worksheet (sheet 1).
|
| I now want to use vlookup again to get some information about a few of the
| users on to another worksheet (sheet 2). The problem I'm having is that
| Excel is not recognising the equal values between sheet 2 and sheet 1. I've
| gone into the cells in sheet 1 to see if there is a rogue space somewhere
| messing me up, and there isn't, but as soon as I hit return then the vlookup
| on sheet 2 starts working. This has the unfortunate side effect of messing
| up the vlookup that gets the information into sheet 1 in the first place!
|
| I've tried paste special to make both columns values only, but it hasn't
| worked.
|
| I can't figure out why clicking on the cell and hitting return would get the
| formula to work.
|
| Any ideas?
 

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

Need VLOOKUP to Work Two Ways 0
excel not recognising numbers containing 0.1calculated by formulas 4
vlookup? 2
Vlookup and return sheet name also 2
0.1 to 0.99 not recognised or calculated when results from formula 5
First column of range in VLOOKUP contains formula 2
VLOOKUP Function to return values in multipal Columns 6
Sum Values from different column 1

Top