C charles Sep 24, 2003 #1 Hi! How can I use the value from another cell as current row refernce number, e,g., A(B2)? Thanks in advance.
Hi! How can I use the value from another cell as current row refernce number, e,g., A(B2)? Thanks in advance.
D dvt Sep 24, 2003 #2 charles said: Hi! How can I use the value from another cell as current row refernce number, e,g., A(B2)? Thanks in advance. Click to expand... =INDIRECT("A"&B2) Dave dvt at psu dot edu
charles said: Hi! How can I use the value from another cell as current row refernce number, e,g., A(B2)? Thanks in advance. Click to expand... =INDIRECT("A"&B2) Dave dvt at psu dot edu
C charles Sep 24, 2003 #3 Dave, Thanks a lot. It works great! dvt said: =INDIRECT("A"&B2) Dave dvt at psu dot edu Click to expand...
Dave, Thanks a lot. It works great! dvt said: =INDIRECT("A"&B2) Dave dvt at psu dot edu Click to expand...
