Hope someone can help me with this.

I have a sheet with over 30000 rows and need to complete it with a couple of formulas.

Problem: In one of these formulas I want to specify a value by instructing excel to look for it this way:

Need Excel to return a value from column G on the same row as the last entry of the value A502 (i.e. the value in cell A502) in column A. This value occurs quite alot of times.

Hope I got that right...

Might be a LOOKUP-formula