Use Excel to return a single value based on a non-unique range?

[falseadvertise]

I posted a similar question a week ago and had a great answer.
The variables have changed slightly here and it changed the way the formula has to be written.

In the old question all my values were unique so a MATCH function was appropriate. Now i have one set of strictly unique variables (column G) and one set of variables that can range from 0-5 (column E).

I think something like a vlookup may be more appropriate but i am not very familiar with them.


My Problem...

I need to pull a value from one sheet and put it on another based on a range of 1-40.

In column E I have E4:E43 (Total 40). All values between 0 and 5.
In Column G I have G4:G43 (Total 40). Values 1 - 40.

What i need to do is return the value from E to a separate sheet based on the value in G. The values in G are all unique (a number from 1-40) but the values on E are a range from 1-5 so i don't think a MATCH function is appropriate.

The reason this is important is because i will need to sort the values in the main sheet based high to low or low to high but the values will change regularly. When i sort the main sheet i need to make sure the second sheet stays constant. (this sheet feeds my matrix)

I might have several cells in my E column that are 3 but only one cell in my G column that is 3.

Ex.

E G
2 1
4 2
1 3
2 4
3 5
2 6
4 7

and so on...

When i sort column E from High to low, i need my second sheet to look exactly the same as before i sorted the main sheet. However, when i sort column E, column G is also going to rearrange itself. On the second sheet, the cells should stay constant. Column G is the base on both sheets.


I hope this was clear,

Any Ideas???