Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

Match partial text string in one sheet to another text string in another sheet
Santos -
Santos -

2 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Concanating text using vlookup forumula
gannesh0604 -
gannesh0604 -

0 responses
Conditional Formatting in a vlookup
attycuz -
TrowaD -

1 response
Find missing data in 2 columns (Excel)
dalami81 -
dalami81 -

2 responses