Search results

Dear Narayan, Thank you! That works brilliantly. Sorry, totally my fault. I should have realised you meant to put the formula in AO on the Master List, not the other forms! One final question - I promise! - I note that, after row 516 on the Master List, as there are no names in the...

Hey Narayan, Thank you. Unfortunately I can't get it to give me the dates, it always comes up as empty i.e. no date, and I sure it's cause I'm doing something wrong. In the formula, SheetList&"'!$AO$2:$AO$200 - do I need to specify which worksheets it is to pick up the information from the...

Yeah!!!! Thank you, that works now, brilliant! Wondering if I can be cheeky and ask one for another piece of advice? I noticed that, although my original search goes by Surname to get the Leaving Date, that there is more than one person with the same Surname (how stupid of me not to...

Hey Rahul, Thank you for this, but I have to be honest and say I don't really understand what I'm looking at, and how to transfer this/what formula etc. to my spreadsheet. From your worksheet - VLOOKUP Array - I tried to 'copy' the formula from Column B and adpated using my SheetList, but I...

Hey Rahul, Thank you, here's the link http://www.fileconvoy.com/dfl.php?id=gbb7c0c90114fc54a999301910e306e1ae3e2a3313

Hey guys, thanks for your comments. Unfortunately I tried all options, including that link you kindly sent, but still no luck. As ths is the first time I've used this website, how and where do I upload my Excel file so someone can have a look at it?

Hi, I'm new to this website, and I am an inexperienced Excel user. Basically I have a worksheet with 4 sheets of information, and one called the Master List which collates information from the other 4. Sheets 1 to 4 are all personnel information from various years. I am trying to find an...