Hi
I wonder if you can help me.
I'm trying to create a semi-auto workbook for a charity.
vlookup
It all started when spreadsheet guide Bill Jelen (aka MrExcel) declared that 25-31 March would be VLOOKUP Week.
2
Excel’s VLOOKUP function is probably second only to pivot tables in popularity for management reporting and accounting users. Simon Hurst looks into its potential applications.
9
Last month, David H Ringstrom discussed ways in which Excel formulae using SUM functions could be extended by using multiple criteria.
5
Anyone working with accounts data will know the soul-destroying tedium of standardising and cleaning data imports so that you can use them for pivot tables, analysis and Vlookups.
Reference ABCDE_____D_____£300.00
Reference ABCDE_____F_____£400.00
PROBLEM: My LOOKUP function is looking for ABCDE and returing £300.00 instead of £400.00.
5
Simon Hurst explains how to use the new Excel 2007 function to streamline error-checking in your spreadsheets.
1
David Carter’s series of Five Minute Tips aims to develop your skill at using Excel pivot tables.
When you use a formula to calculate a new column of numbers, Excel will sometimes display error messages such as #DIV/0! if a number has been divided by zero.
