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