Forum Discussion

Machala Sentance's avatar
Machala Sentance
Brass Contributor
May 19, 2021
Solved

Lookup Formula help

Hi,   There is probably a simple solution to this, but I just can't seem to get my head around it.   I have a drop-down box and I need to be able to identify all of the tabs that the data in the ...
excel
Formulas and Functions
  • Machala Sentance's avatar
    Machala Sentance
    May 19, 2021
    @hansvogelaar
    The data/activity will be in A158:A175 on each sheet and the dropdown will be on tab called "Staff by Activity" in cell B5, and all the names listed in column C - like the example, I think it's just where it needs to look that I am unsure about in the coding,

    Thanks again
Machala Sentance's avatar
Machala Sentance
Brass Contributor
May 19, 2021
@hansvogelaar
The data/activity will be in A158:A175 on each sheet and the dropdown will be on tab called "Staff by Activity" in cell B5, and all the names listed in column C - like the example, I think it's just where it needs to look that I am unsure about in the coding,

Thanks again
  • Machala Sentance's avatar
    Machala Sentance
    Brass Contributor
    May 19, 2021
    HansVogelaar

    Hi Hans, thanks for your help I have managed to work it out,

    Thanks again

    Machala

Resources