Using unique number to filter information

Closed
kermitchell Posts 1 Registration date Tuesday June 26, 2012 Status Member Last seen June 26, 2012 - Jun 26, 2012 at 06:54 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 28, 2012 at 09:26 AM
Hello,

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.

Would be so greatful for some guidance!


1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 28, 2012 at 09:26 AM
Hi Kermitchel,

Have you tried VLOOKUP?

To retrieve the name:
=VLOOKUP(A2,Sheet1!$A$2:$D$2,2)

To retrieve the payroll no:
=VLOOKUP(A2,Sheet1!$A$2:$D$2,3)

etc...

"A2" is the location of the voucher no on sheet 2.
"Sheet1!$A$2:$D$2" is the matrix to look at.
"2" will be the column of the matrix to retrieve info from.
Change range(s) to suits your data.

Best regards,
Trowa
0