Lookup Help

[EB08]

Not sure which way to go or if it can be done. Is it possible to search for a value in column "A" (lets say its found in row 21), then search row 21 for another value (lets say it's found in column "D") and pull the value in the cell below that. So in this case, i'm looking for the value in "D22". I know this is vague and terrible example and I apologize for that, i'm having a difficult time finding a way to make this work and i'm really hoping it can be done. Thanks again.

 

[EB08]

probably right about the cringing part...i'm sure there is always a more efficient way to go (which i would definitely like to see). But hey, it worked for what i was using it for.