VlookUp Problem?

Closed
akram786 Posts 7 Registration date Wednesday April 30, 2014 Status Member Last seen June 30, 2014 - Jun 17, 2014 at 08:54 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 17, 2014 at 09:45 PM
I have 4 Column A,B,C,D
A=date
B=MarketValue
C=Results
D=Numbers

when i use the vlookup formula in other sheet it not working
=vlookup(A2,Sheet1!A3:D100,1,False)
and then Result is #N/A

what i do now?

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jun 17, 2014 at 09:45 PM
akram786, Good evening.

It's not a VLOOKUP problem.
This answer is because the date of A2 don't exists at A column of Sheet1.

Are you sure that exists this date there?

What exactly you need?
0