Is there any functions to get the specific content in google sheet?-CodePudding

I am making a company staff meeting attendance record form, now I want to through the function to directly get the data of staff in a specific date, but because the column of the data is not uniform, so the basic Vlookup() can not achieve this effect. For example, I want to search the form by staff name to get the content of 1.24 (cell content contains 1.24). I would like to ask how to achieve this function and I would appreciate if u can help me. thank u!

My record form is here:

I've tried to do this by Vlookup() function but failed. It just can get the data in specific column. I want to get the data that contains specific date.

CodePudding user response：

Let's say you insert your date in B19, you can erase your formulas in B20:B24 and use:

=BYROW (A20:A24, LAMBDA(each,IFNA( FILTER (INDEX(D1:Z12, MATCH(each,A1:A12,0)), REGEXMATCH(INDEX(D1:Z12, MATCH(each,A1:A12,0)),SUBSTITUTE(B19,".","\."))))))