VLOOKUP across multiple sheets using dependent dropdown

[Donutderek]

Using a dependent dropdown, I have multiple values all with different source locations. I have used VLOOKUP to automatically populate a cell next to a drop-down.

=VLOOKUP(C13,'SheetX'!C5:D5000,2,FALSE)

However if I select B from the drop-down, how do I get VLOOKUP to do the same thing? The source info for B is on another sheet in another cell group. I've read it can be done with INDIRECT or INDEX/MATCH, but how to nest this formula is where I'm lost.

Any advice?

 

[DanteAmor]

Oh Yaaaaaassssssss, Dante!
Thank you so much. This will work.

I'm glad to help you. Thanks for the feedback.