Excel Formula

[brain_chilled]

ok, doubt anyone on here is that knowledgable on excel, but really hoping they are!

I'm currently working on a project for work and was wandering if anyone could point me in the right direction.

I have set up a front input sheet(worksheet 1) where you type in someones personal data, a second work sheet where data will be stored, and three worksheets which are letters. The idea is that you input the data in the first worksheet and press the button which saves it to the second data worksheet, and also copies that data (name and address) onto the third which then prints.

I have this set up as a macro which was fairly easy to do.

however, its been a while since my university days and am now stuck. what i would like it to do is determine if the persons details have already been entered, if its the first entry on the spreadsheet to print the first letter (sheet 3) second entry to print the second letter (sheet 4) or 3rd entry to print the third letter (sheet 5). i would like it to look up the surname and forename stored in different cells from the input sheet 1 on the data sheet 2.

Could someone please point me in the right direction as to what formula i need to do this as im starting to pull what little hair i have out!

[P UNIT 1980]

Lol mate best of luck ther are a pigs tit to work out.

I barly manage to add up on the poxy thing.

Always end up getting the calculator out!!!

[Morecambe Yid]

sounds like u need to use =LOOKUP() and then a nested =IF() for the rest - do you wanna PM me an example and i will have a look at it (i Used to teach Excel n Access).
Be warned i am a little rusty

[yid4eva]

sorry mate excel is not one of my strengths

[brain_chilled]

Cheers, figured out that if i have a COUNTIF then a standard IF it should work

[SirBillyNick]

Cheers, figured out that if i have a COUNTIF then a standard IF it should work

tbh mate the first line of your original post didn't really get people clambering to help

[BatchSpurs]

I feel for ya, I had some alone time with Excel yday - and came to the conclusion that its mans worst invention since the Woolwich Wanderers.

The pinnacle of my Excel romance yday?

=IF(OR(B4>$B$37+2*$B$38,B4<$B$37-2*$B$38 ),"Outlier","Not Outlier")

......tells you all you need to know about Excel = !!xollod

[kevfball63]

I been avoiding this thread because the title was like chinese to me . I was wrong its worse = its like japanese to me

[Morecambe Yid]

Ni-Hao-Mah Kev ?

[ctw01]

Ni-Hao-Mah Kev ?

Hello mate how are you ?

[brain_chilled]

yes, excel is truely the bill gates and the devils love child. why cant the job reach into their pockets and buy access. cheap bar-stewards! ive given up on the formulas and moved onto VB macros... how did it ever come to this?

[SirBillyNick]

yes, excel is truely the bill gates and the devils love child. why cant the job reach into their pockets and buy access. cheap bar-stewards! ive given up on the formulas and moved onto VB macros... how did it ever come to this?

excel was not created by Microsoft

[BatchSpurs]

excel was not created by Microsoft

......I smell an Excel/Microsoft history lesson comin on!!