I have some data on a sheet and I want it on other sheet without using lookup function. Only "Indirect function need to be used". Please find attached the excel sheet.
Thanks in advance.
I have some data on a sheet and I want it on other sheet without using lookup function. Only "Indirect function need to be used". Please find attached the excel sheet.
Thanks in advance.
Copy and paste formula in B3 drag across and down.
=INDIRECT("'Q6'!"&CHAR(66+COLUMN(A1))&ROW(A8))
I didn't realize that dates on Ans 6 sheet are not consecutive. There are Apr 1 and Apr 3. So this would require another INDIRECT formula in I3
Across and down.This will get data for Apr 3
=INDIRECT("'Q6'!"&CHAR(69+COLUMN(H1))&ROW(H8))
See updated spreadsheet
Last edited by AlKey; 01-18-2014 at 11:42 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks