J
jt76
I have say a 26 by 26 grid of info and the row 1 is filled with values
A-Z and column A is numbered from 1-26. How do I write a function that
will search Range A-Z(Row 1) and then search range 1-26 (Col A) and when
it finds the two values if will return the value in the cell they
intersect?
ex.
given a 3x3 grid. top row of cells are filled with A, B, C and first
calumn is filled with 1,2,3. I want a function that will return the
value in (B,2).
Thanks.
A-Z and column A is numbered from 1-26. How do I write a function that
will search Range A-Z(Row 1) and then search range 1-26 (Col A) and when
it finds the two values if will return the value in the cell they
intersect?
ex.
given a 3x3 grid. top row of cells are filled with A, B, C and first
calumn is filled with 1,2,3. I want a function that will return the
value in (B,2).
Thanks.