why am i encountering result N#A when doing the VLOOKUP function
|
why am i encountering result N#A when doing the VLOOKUP function
Read HELP.
If you need more, post your formula and the data involved. -- Kind regards, Niek Otten Microsoft MVP - Excel "Mame" wrote in message ... |
why am i encountering result N#A when doing the VLOOKUP function
it's because the lookup value cannot be found, If you are only worried about N/A then use this ISNA function like this: =IF(ISNA(VLOOKUP(A1,A2:C10,2,FALSE)),"None",VLOOKU P(A1,A2:C10,2,FALSE)) You can change ISNA for ISERROR to handle all errors. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91198 |
All times are GMT +1. The time now is 01:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com