Forum Discussion
Automatically fill informations
Hi, is there anyone who can help me? I want to fill up a cell using the information from different worksheet based on their names in the worksheet, is there any formula to do it automatically?
Hi iamheiz,
Yes, there is a way.
But in order to do it, you have to write the name of your worksheets on the cells.
Like this:
Using the figure above,
Enter this formula on your desired cells to fill up (ex.: cell: "C5").
=VLOOKUP($B5,INDIRECT("'"&C$4&"'!"&"B5:C11"),2,0)
Explanation and Source:
ExcelJet.net
LOOKUP using SHEET NAME as LOOKUP VALUE
Pinaka gwapo,
Rodrigo_
