Mapping Multiple Dropdown Lists to extract certain data

[Trotwood787]

Hi,
I've created 5 drowndown lists, in columns A to E.
The possible options of each list is based off of the selection of the list to it's left.

I used data validation =INDIRECT(SUBSTITUTE(D2," ","")) to make this work.

What I'm trying to achieve is for column F to give me a certain GL that would be based off of the 5 dropdown lists.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Employee[/TD]
[TD]Expense Type[/TD]
[TD]Show[/TD]
[TD]Description[/TD]
[TD]Currency[/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]Sales[/TD]
[TD]Show[/TD]
[TD]National[/TD]
[TD]Meals[/TD]
[TD]CAD[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I have a list of roughly 500 GL's, and need to use this so that when employees enter their expenses, it auto populates which GL to use.

Any suggestions?

Thank you!