Forum Discussion
matching 2 spreadsheets list
I have a 2 excel docs, one with my target customer# and the second excel doc with all customer#. I want to match and sort the 2nd sheet with all customer# to match my target customer#
=CHOOSEROWS(A2:G30,BYROW('target customer#'!A2:A23,LAMBDA(r,XMATCH(r,A2:A30))))
Is this similar to what you are looking for? The formula works in Office 365 and Excel for the web.
