Thread: Excel quotation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KathyIris KathyIris is offline
external usenet poster
 
Posts: 1
Default Excel quotation

I want to quote value of a cell on differnt tabs, location of the cell is
defined in column B. Now i have

A(tab name) B C
1 aaa H121
=INDIRECT("'" &A1& "'!H121")

How can C1 use B1 in the formula instead of calling "H121" out directly?