MATCH against All Columns return SPILL Dynamic Array

Given the tables below, and that I have a dynamic array values to lookup of (A9:A11), How do I get the INDEX MATCH value, where the MATCH have to lookup at all columns.

I was able to do it via 1 cell and then copy down the formula, but I'd like to apply it dynamically. I tried using BYROW(LAMBDA(...)) functions, but it returns a #VALUE! instead.

What did I miss here?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

LOOKUP against all columns return Spill Dynamic Array.png

PS: I'd like to emphasize here that if the lookup value (cell AA9:A11) happens to be 0 or blank, then I'd like to return blank ("") instead of returning Table1[Parent ID], since I have many blanks in the ID #* columns

I think you're not doing anything wrong, but it's due to a limitation of Microsoft in the LET function.
Without LET, things are going well. See attachment.

EDIT, Sorry After posting, I saw that Belinda had sent almost the same reply.