Hi Y'all!
I'm trying to find the row number where:
FORMEDIT A:A = B2
and
FORMEDIT K:Z = A2
The contents of A2 could be any of columns K to Z.
=match(1,(FORMEDIT!K:Z = A2)*(FORMEDIT!A:A = B2),0)
Then using that row number, I'm then putting it together into an index|match...