Forum Discussion
Solved
This should be a simple problem
I've used the MATCH function to find the row in the column that matched what I'm looking for. I now want to see the value in a different column in that row. I can't find a way to build a cell refer...
so CONCAT will create a TEXT value of A11 and that is different than a cell reference.
As noted by Detlef you can use =INDEX(A1:A100, MATCH( .... ) )
You can (and should consider) use XLOOKUP( ). This is a newer function (need 2019 or 365 to use) and is more versatile and more efficient. =XLOOKUP( value, lookup_array, A1:Axxx, "not found") I put Axxx in the range because the return_array and lookup_array must be the same length.
Try INDEX().