VlookUp Problem?

Closed
akram786 Posts 7 Registration date Wednesday 30 April 2014 Status Member Last seen 30 June 2014 - 17 Jun 2014 à 20:54
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 17 Jun 2014 à 21:45
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 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
17 Jun 2014 à 21:45
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?