Dropdown Menu & VLookup formula not working

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Dear All

    I make this table, and I try to make search feature by using drop down menu and vlookup formula, I use data validation to add HVAC Unit & Number, the problems am facing the following:

    1. After I add HRU units number, I change HVAC Unit to FCU and I try to add drop down list for number from below table after I do this step through data validation it will change also number for HVAC unit.

    2. After changing number it will not return correct data for Building, Location and Level from below table.

    Please advise what is the mistake I did and how can I correct it. " I want to learn :) "

  • Try using the FALSE switch in your VLOOKUP =VLOOKUP(A2&B2,Table1[#All],5,0) to get an exact match

    You are using the TRUE switch (1)

    BTW your file is "Read-Only"?

  • Thank u it worked! but again had the issue with after adding data validation list of AHU as drop down list for number, I change to HRU and from number I go to data validation and I choose that HRU number.

    If I go back to AHU the number that I choose previously it gone and only number for HRU it will be showing how comes?

  • I open the test file same issue exist, my problem is how to add data validation for HRU and FCU without changing data validation list of AHU ?

    If I choose FCU , numbers will show for example 302 and 304

    If I choose HRU, numbers will show for example 5

    What is the correct process to do it , please teach me that

  • Thank u it worked but can u explain to me

    To understand how does the two formula worked ?

    Try to use the "Evaluate Formula" feature, that resides on the Formulas tab, in the "Formula Auditing" group.

    All you need to do is click the Evaluate button and examine the value of the underlined formula part.

    The result of the most recent evaluation appears in italics.

    Continue clicking the Evaluate button until each part of your formula has been tested.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!