You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
Hey!
Here's a question about xlookup!
I know it can spill over to columns to return all the values in the return array (neat!).
But.
Say i want to search someone's DOB. this is not a unique ID.
if i do this:
=COUNTIF(Table1_1[Patient Date of Birth],B4)
I'll get the number of times that DOB is present.
How do I get this :
=XLOOKUP(B4,Table1_1[Patient Date of Birth],Table1_1[Patient Forename]:Table1_1[Patient Gender],0,0)
to spill to the countif value? can i?