Formula/Logic Required PLEASE ;-)

[Yupyup]

I have two fields being defined one named Eng and other could be any variation of text. Based whatever the user inputs here I then need to look at the dollar value specified by the user. Based off these two criterias I then need pull the appropriate response for two different cells.

Many thanks in advance!

Eng

Amount Range	Approvers (P104)	Addiitional Approvers
0.01 to 999.99	approver 1	approver 6
1000 to 4999.99	approver 2	approver 7
5000 to 7499.99	approver 3	approver 8
7500 to 9999.99	approver 4	approver 9
Whatever (could any text combination)
Resource	Amount Range	Approvers (P104)	Addiitional Approvers
0.01 to 999.99	approver 10	approver 14
1000 to 4999.99	approver 11	approver 15
5000 to 7499.99	approver 12	approver 16
7500 to 9999.99	approver 13	approver 17

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[oldbrewer]

give us a working example please

 

[Yupyup]

give us a working example please

Thanks! Please see the below which hopefully provides enough of an example.

If a users enters Eng in a cell and the dollar value of $1500 in another cell. It should then pull the value back from the Eng chart looking at the Approvers (P104) column and populate approver 2 into a cell. In addition, it would pull value in the Additional Approvers column back which would approver 7 into another cell.

 

[oldbrewer]

Eng
Amount Range	Approvers (P104)	Addiitional Approvers
0.01 to 999.99	approver 1	approver 6
1000 to 4999.99	approver 2	approver 7
5000 to 7499.99	approver 3	approver 8
7500 to 9999.99	approver 4	approver 9
	amount=	1500
0	app1	app6
1000	app2	app7
5000	app3	app8
7500	app4	app9
10000	none	none
app1	app6
by amending the table layout a simple vlookup formula pulls the required information

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>