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
Hi Hans,

Thanks for the quick reply - rooky mistake on the example, if my look up is in A158:A175, and the drop down is in B5, which range bit is which? (I should have put them in different cells 🙂 - sorry not good with VBA - I have changed the sheet name it's just the look up bits/ranges.

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