Consolidate function for result of VLOOKUP

[Morrighain]

I am using EXCEL 2013 and am trying to find out if there is a way to auto-update the consolidate function. I am using a vlookup based on a data validation and would like to consolidate the result automatically when the value in the validation cell changes. I can't post the worksheet here for data security reasons. Any help would be appreciated.

 

[mart37]

use the condition for your data validation in your lookup

place an example what you have and what you will get

 

[FDibbins]

It would help if you showed a sample of what you are working with, as well as what formulas you are using and what you expect.

What exactly do you mean by "I am using a vlookup based on a data validation and would like to consolidate the result automatically "?