Data Validation List and Vlookup combined

Hi Meunixx,

Here is one alternatives without dropdown list to get what you want assuming that the contract no. of cancelation always below the fresh contract number .. I don't know if there is any way to combine drop down list and formula in 1 column. Hope this help

Book4.xlsx

Hi Jul Stev

I trust that you are well. I have a similar problem with data validation and vlookup. In my workbook I created a simple drop down menu in cell A460 to select your steel section type. From this it should create a drop down list in cell B460 with all the standard sizes of the selected section in A460. My table range is $A$18:$B$441 and I've tried inserting the following formula into a data validation for cell B460: =INDIRECT(VLOOKUP($A460,$A$18:$B$441,2,FALSE)). It returns the following error message: "The source currently evaluates to an error. Do you want to continue?" What am I doing wrong? Please see my attached workbook

Kind Regards
Theo
Job Measuring Formula Sheet - Structural Steel, REV 1.xlsx

Hi Jean

Thank you, but this didn't solve my problem. The Drop Down list in column B should be created according to the selected steel section in Column A. Please have a look at the file I have attached in my first post.

Kind Regard
Theo

Pl see the attached file.

Thanks for the help ..
But it didn't work as your solution is based on the assumption that every new fresh booking will have a separate invoice no. for it. I forgot to mention in my query that 2 or more fresh bookings can have same invoice no. My Bad.

Thanks Anyways

Originally Posted by kvsrinivasamurthy

Pl see the attached file.

Thanks for your reply. The sheet you've attached gives the exact solution to the problem.
However,

I tried to copy/paste the VBA coding in it in my sheet and edited it. It works fine till the time " Canc." is being selcted but as soon as " Fresh" is selected there is some error showing in it. cz of my lack of knowledge of VBA I don't understand where is the problem.

Can you please look into and correct it.

Hi Guys.. I have a similar problem. I have Names in one column and their role titles in 2nd. I want a formula to select Names in 1st column and it should return titles in 2nd column but If I select "Select by Role" in 1st column then it should give me drop down list of role titles in 2nd column. Can you help me with formula