Change the Validation contents as per the given inputs

Hello Friends

Please refer the attached file.

I need to change the validation contents in light yellow cell by using the inputs.

thanks in advance.

Im sorry, your request makes no sense to me. Can you explain what you are trying to do?

Yes it sounds like it should be the other way around.

If in Input cell say in G3 is ABC then the validation shows the contents of B2:B9, if the cell G3 is XYZ then the validation should shows the contents of E2:E6.

Give each list a range name (ABC and XYZ in your sample), then use INDIRECT() to get the comtents

Hello Ford

Thanks for your reply,

By using your comments i did myself, refer the attached file.

thanks again

excellent!! Thanks for the feedback