Good morning, would like a help with the references in a spreadsheet: I have the following situation.
In the cells in column A I have a list with the name of my computers PC A PC B PC C and each cell has a tab of the worksheet with the same name, I would like to make a reference formula with the cell name to open the spreadsheet ex: =IF(HLOOKUP(C$4;
PC A!$C$3:$N$14;12;0)=7;" REALIZED";" PENDING") >> in place of the spreadsheet reference "PC A" has how i indict the cell and it navigate to the tab?
I don't know if I was clear, but I would like to change the structure of the formula so that when I want to write the name of the worksheet, I put the cell and he understood that i should open the
worksheet.
Instead of "PC A!" >> put something like "A2" &
! >> for him to run the formula in this reference worksheet, is there any way to do something like that?
This would make it easier to, I have a gigantic list of "PC" and not to create spreadsheet by spreadsheet, if I did this reference directly with the cell, would help me a
lot.
Thank you, i'm
sorry.
Bookmarks