Forum Discussion
Pull member ID number from sheet 2 into sheet one if the name matches?
Sheet 2 has the entire member list for our club and all the individuals' information, but Sheet 1 only has select few names that need to have badges printed. Is it possible to come up with a formula that can read the names on sheet 1 and match them up with the names on sheet 2 and give me the additional column of info? Currently doing each individually and a formula would save so much time.
Columns on both sheets are Member ID, First Name, & Last Name.
You could use an XLOOKUP (Sample attached):
=XLOOKUP(B2:B7&C2:C7,Master!B2:B7&Master!C2:C7,Master!A2:A7,"")Patrick2788 I tried to plug the formula in using the actual Sheet Names and columns but it doesn't seem to work for me. I do have a column in between the member ID and first name that I thought would be irrelevant that is a code to turn the member number into a barcode. Here's a bogus name list to give you a more realistic idea. It's possible I was entering the wrong values in the wrong spaces. Whole list is well over 1000 and maybe 30 or less need to be on the first page. Would update the names and -hope- the other column would update as well.
Thank you for the sample workbook.
This is the formula for the sample:
=XLOOKUP(C2:C6&D2:D6,'Whole List'!C2:C11&'Whole List'!D2:D11,'Whole List'!A2:A11,"")Make certain the ranges specified in the XLOOKUP are of equal length. If one column is longer than another, it will result in a #VALUE error.
