Previous Topic Next Topic

Excel 2007 VBA #n/a Lookup

Closed
Tjones4852 Posts 11 Registration date Monday May 10, 2010 Status Member Last seen December 9, 2011 - May 11, 2010 at 10:37 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 11, 2010 at 11:24 AM
I have a sheet receiving imported data and sometimes it does not come in correctly so I use Vlookup to verify it against the correct code as part of a macro to set up all the sheets form the import.

Rather than have the user go through the sheet looking for #n/a I would like to stop the macro and bring up a msgbox advising the user what cell is in correct - allow them to change it and continue the macro.

Is there code for this - It requires a user to select the correct code.

Related:

1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
May 11, 2010 at 11:24 AM
Not sure what you are asking. May be this will help. If you allow the column to be filled with vlookup and and you can apply filter and filter on #N/A to see which rows have error
0

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses