Drop Down List

[TekleMeElmo]

I have a worksheet that has vlookup data in it and it’s looking up a name that I select from a drop down list and it’s looking up that name on another sheet and returning the values. I want to add another drop down list to select 2023 or 2024 so I will have 2023 and 2024 in my drop-down list. I want to be able to select year 2024 and it shows my vlookup data for 2024 but if I select 2023 year, I want it to show the vlookup data for the 2023 year.
Can anyone tell me if I can do this?
I have 2024 added to my drop-down list but of course it just shows vlookup data for the 2023 year. I want to be able to select 2024 and it basically clears the cells and then use that same vlookup to populate data for 2024.

I’m sure I can create an example excel file to share if it would be better.

[russkris]

Hi,

Yes please, its difficult sometime to understand how your workbooks are structured. Check the yellow banner at the top.

[Danny44]

Hi,
See example below.


LookupVconditional.xlsm

[protonLeah]

Create named ranges:
Year2023 ='2023'!$A$1:$B$5
Year2024 ='2024'!$A$1:$B$5

Cell A36:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.