filter data using unique voucher number (solved)!

Hello,

Can anyone help, setting up childcare voucher scheme and have set up register in excel in sheet 1
a2- voucher no ie. 1 (unique value)
b2 - name
c2 - payroll no
d2 - childcare provider name

in sheet 2 i have made up childcare voucher that gets printed off and given to employee

Ideally in sheet2 if I type in voucher number information the rest of the information would filter into the form.

Hope this makes sense I have attached my worksheet.

Would be so greatful for some guidance!

Hi

In Form!B5, try this.

=INDEX(Register!$B$2:$B$37,MATCH(B3,Register!$A$2:$A$37,0))

Same way for the others.

Hi,

Does the attached give you some ideas?

For the Name, put in cell B5 FORM Worksheet the following:
=VLOOKUP(B3,Register!A2:D37,2)

For the Payroll Number, put in cell B6 FORM Worksheet put in the following:
=VLOOKUP(B3,Register!A2:D37,3)

To add the child care provider the formula is:
=VLOOKUP(B3,Register!A2:D37,4)

If this help, click on the star at the bottom of this message and change the title by adding [SOLVED]

Kirk