jana
asked on
MsOffice Excel 2010 vLookup seems not to work properly
Attached is an excel with the function of vLookup seems not to work. Note that the table-array contents and the lookup-value are the same, there values that are the same but the result displays #N/A.
Why is this happening and how can we fix it.
Why is this happening and how can we fix it.
Hi,
Some Numbers are stored as Text pls convert
VLOOKUP has problem with it some times
Regards
Some Numbers are stored as Text pls convert
VLOOKUP has problem with it some times
Regards
ASKER
Don't understand.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked excellently!!!
Please explain how the &"" solved this problem (we would like to understand)
Please explain how the &"" solved this problem (we would like to understand)
ASKER
thanx
ASKER
vLookupNotWorking.xlsx