Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

reference sheet name from cell value


There was a similar questions posted I think but it was so vague I really couldn't understand what was actually be asked or the answer provided. So please do excuse me if this has been answered already.

I want to use a cell value to reference a sheet. Column “B” contains item_code that matches a sheet name for example TILKGW68

Price column for example contains =TILKGW68.F2.

Challenge: Instead of having to spell out each sheet name in the Price column I would like to reference column B.

I have a simple example ODS file to attach but it seems I am too new and need 3 points before i can upload. Since I am new, I don't know what these points are or how to acquire them. Hopefully I have included enough detail above to explain my objective.

Thank you