Search results

No need to be rude now... How do you know I have not been trying hard? I have been working at it for days with the understanding I have of excel and searching the net to learn more. I have it working now anyway thank you. A friend from finance helped on it this morning as well and moved it all...

Hi I have tried creating new column and copying and paste special values into the new column (formatted for numbers), deleting old column and typing formula again. Still no joy. Regards Benn

Hello again I tried formatting both column A's cells as Number this morning and it did not work, is that similar? Just tried formatting as number again now and no luck with formula. I have also selected the cells in column A sheet 2 and do not get a little pop up with 'convert to number'...

Hi there, Yes, I have tried using the formula wizard, again to no avail. Regards Benn

Hello all, I am trying to get a vlookup to work and it is stubbornly refusing! Any help as to what ive missed would be much appreciated. I want to bring back data from worksheet 2 and return it to worksheet 1 in the same workbook. The search and refernce values exist in both worksheets in the...

Hi again sorry hectic time here. my solution didn't involve Excel at all. our Access DB had buckled under recent pressure and not giving accurate data so whilst our new SQL DB was being implmented we had to run forecasts from Excel. one small part was this area reference. in Access it was a...

Hello all Thank you for your help so far we have found a resolution to our problem now. Regards Benn

sorry, forgot to attach file. Regards Benn

Hello again I have attached a spreadsheet with a sample of the data, its all under the freedom of information act, no sensitive data therein. I would like to match up 'birthwards' to schools. The first worksheet is a list of schools. The second worksheet in a list of birthwards, which are...

Hello Is it possible to make a vlookup formula that will return more than one value from the column it is searching? I have a list of entries on one workbook which also exist in another workbook with additional data in the next column. The entries may appear more than once in the second...