Thread
:
inserting data from a row to a cell, when the row number is specified by a formula in a cell
View Single Post
#
3
Max
Posts: n/a
Another play is to try INDIRECT() ?
Put in C3: =INDIRECT("R"&H3)
where in H3 is: =MATCH(I2,(Q$1:Q$30001),0)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Reply With Quote