Forum Discussion
Pull member ID number from sheet 2 into sheet one if the name matches?
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.
- Patrick2788 When I plug that in, I get #NAME? as my error.. Not sure what I'm doing wrong.. Does the formula require a 365 subscription?
