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 ...
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.