inserting data from a row to a cell, when the row number is specified by a formula in a cell

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I make a formula NOT change when the data range is moved?	Alida Andrews	Excel Discussion (Misc queries)	2	January 6th 05 09:02 PM
Convert data of cells to any type: Number, Date&Time, Text	Kevin	Excel Discussion (Misc queries)	0	December 30th 04 06:55 AM
How do I add a date formula to a cell but hide the contents with .	Emzy Wemzy	Excel Discussion (Misc queries)	2	December 12th 04 01:48 PM
Aligning Two Lists in Excel	Rich	Excel Discussion (Misc queries)	2	December 4th 04 05:44 PM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula?	Arvi Laanemets	Excel Discussion (Misc queries)	0	December 2nd 04 11:29 AM

All times are GMT +1. The time now is 02:19 AM.

Menu

About Us