Forum home » Delegate support and help forum » Microsoft Excel Training and help » Anthony

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Anthony

Resolved · Low Priority · Version 2007

Reply Wed 16 Nov 2011, 16:44Delegate Karen said...

Karen has attended:
Excel Advanced course

Anthony

Anthony whats with the vlook up?

For upcoming training course dates see: Pricing & availability

Reply Fri 18 Nov 2011, 06:37Trainer Anthony said...

RE: Anthony

Hi Karen, thanks for your query. There's quite a lot on the net about this problem so you're not alone. Have a look here:

http://help.lockergnome.com/office/Vlookup-returning-NA-referencing-cell-data-sheet--ftopict1006537.html

...and here:

http://www.accountingweb.co.uk/anyanswers/vlookup-na-returned

Try here for some workarounds:

http://www.free-training-tutorial.com/shortsum/vlookup-isnaShortsum.html

and here:

http://www.ozgrid.com/Excel/stop-na-vlookup.htm

See if any of that works on our data and let me know how you get on.

All the best,

Anthony

Thu 24 Nov 2011: Automatically marked as resolved.

Excel articles

· How Excel Training Can Improve Your Company's Sales Process
· Find Out Your Age In Days With Excel
· Microsoft Excel 2007
· Create An Improvised Bar Chart In Excel
· How To Manage Your Everyday Spending In Excel

Please browse our web site to find out more about
basic excel training and other Microsoft training courses.

Excel tip:

Adding multiple rows in an Excel 2010 Worksheet

If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.

Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy