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
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- 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 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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