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.