Find all data base on their position

[Adamlearnexcel]

Dear experts

In my data report.

I want to find information located at cell 1732,1954,2022,2055,2061,2063,2065,2112,2113,2114,2115,2116,2117,2119. How can I display all cells information at the same page?
Thank you so much

[dilipandey]

Ok... but which column?
Also, Try looking at Indirect function and in case you stuck anywhere, upload a sample workbook. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Adamlearnexcel]

Dear Dilipandey

Nice to see you again.
I want column from Y to AI for every cells can be display.
How should I do this?

[dilipandey]

Hi Adam,

You can use Indirect function as

Please Login or Register  to view this content.

Where A1 and A2 are the reference to the column and row, see attached:-
find data based on their position - indirect.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>