Forum Discussion
Variable index lookup based on cell value
I am using the formula below =IFERROR(INDEX([170opscentre.xlsx]Sheet2!$C$2:$C$11,MATCH(B10[170opscentre.xlsx]Sheet2!$B$2:$B$11,0)),"") Works fine but is it possible to swap out the array (locati...
VLOOKUP($B2,INDIRECT(""&C$4&"!"&"B2:C12"),2,0)
By Above formula you can lookup based your values in cell. If you want to learn more basic to advanced level concepts then you can joinhttp://www.cetpainfotech.com/technology/advance-excel-training where you will learn all things related to all excel formulas etc.
Thanks a few people suggested indirect but the workbook needs to be open for that to work