Excel help please!

bonkers007

Hi all, wondering if you can help me please...

I used to work for a very large company in which their H&S dept that I worked in set up a excel sheet for accident reporting.

the first excel sheet was a standard sheet to keep info on with details such as:
column a1)accident reporting number
b1)title (mr/mrs etc)
c1) first name etc
d1 surname
e1) address
f1) accident


etc

Now I remember when I used to use it in sheet 1 I would use a new row, fill it out and then I would insert the accident number in a box on sheet 2 which would be a pre done letter, (which contained some standard blurb) but by filling out the accident number, it would fill out the name, address, accident etc on the letter so that it could be printed and sent out

does anyone know how to do this as its something I need something very similar at a new job and I just cant work it out!

thanks all!

p00hsticks

I think it could be done using the VLOOKUP function ?

bonkers007

thanks for that! Shall have a play and see what I can do!

bonkers007

its not Vlookup and its not mail merge... any other ideas please?

johnmc

In the second sheet select where you want the title to go and type "=" (without the quotes), go to the 1st sheet and select the the cell you're interested in.

Repeat for each field.

CAN1976

Sounds like macros maybe?

EchoLocation

bonkers007 wrote: »

its not Vlookup and its not mail merge... any other ideas please?

Regardless of what it was, it's the VLOOKUP function you want. You could also use the DGET function just as easily.

Personally, in both cases I'd get the results in a single row on Sheet2 and then use those cells as dependents for the letter fields.

cookie365

If it wasn't done with VLOOKUP, it should have been.

Though the fact that the letter itself gets produced in Excel and not as a mail merge in Word suggests it's probably about 8000 nested IF statements