May 23 2022 09:19 PM
Hello Everyone,
Tried the formula and it works for FIRST NAME
like -
But when i have done autofill, i got same value
like -
So what should i write formula to return all values and it should be dynamic?
Please help..???
Here is a attached file...
May 23 2022 09:38 PM
Solution@Excel You should index the entire Data range and add a MATCH to find the correct column number. See attached.
May 23 2022 09:38 PM
Solution@Excel You should index the entire Data range and add a MATCH to find the correct column number. See attached.