Using Complex formula in data validation List with OR in formula

[oblix]

Hi there
I Have a data validation drop down list that uses this formula:
=INDIRECT(INDEX(tblNameLU[ListName],MATCH('KEY MENU'!$B1,tblNameLU[Desc],0)))

I would like to include the following:
If cell d19 = "LM" then use formula above, but If d19 = "MM" the use this formula:
=INDIRECT(INDEX(tblNameLU[ListName],MATCH('KEY MENU'!$R1,tblNameLU[Desc],0)))

Basically use column B or R based on d19 answer
Was thinking of including the OR in this formula but dont know how
PLS assist
Thank you

 

[6StringJazzer]

I have not actually tested this (hard to do without your file) but try this. What if D19 is neither LM nor MM?

=INDIRECT(INDEX(tblNameLU[ListName],MATCH(IF(D19="LM",'KEY MENU'!$B1,IF(D19="MM",'KEY MENU'!$R1)),tblNameLU[Desc],0)))

 

[oblix]

Thank you 6StringJazzer for reply
Unfortunately not working
Can I send File to you to figure out and then we post solution here afterwards?

 

[oblix]

Thank you for assist
realized that I had to re-think the whole sheet and formulas. Used helper cells rather to make things easier
Thank you once again

 

[oblix]

Great Thank you to 6StringJazzer for putting me on the right track with formula

 

[6StringJazzer]

Sorry, I'm unclear here. Did you solve this, or do you still need help? I got the file but I don't know if it is before or after you added the helper cells.