I have following formula.when the result is false it appears #n/a.how can I change ther result if false to zero instead of #n/a.Rgds
=VLOOKUP(K6,$A$5:$H$200,2)
I have following formula.when the result is false it appears #n/a.how can I change ther result if false to zero instead of #n/a.Rgds
=VLOOKUP(K6,$A$5:$H$200,2)
which implies that A5:H200 is sorted in ascending order on A5:A200. You can get #N/A (a) if K6 is lexically earlier than the value in A5 or (b) K6 is empty or houses a formula-blank for which nothing exists in A5:H200.
thank for help.I am using above formula.The problem which I am facing is that for one user ID I am getting value of another user ID.For example for user ID2 I am getting the value of user ID4.That means both ID2 and ID4 has same value.Could anyone please help what can be the problem.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.