double vlookup in a range

  • I'd like to do a vlookup like this...
    first find "smith"
    then once smith is found look in the the range 4 columns over (column E) and a range of 10 rows down, and look for "cross", then return the value 1 column over from cross.
    Is this possible?

    basically smith will be found in say cell A324, then I want it to look in cells E324:E33 for "cross", lets say found in E329, then return the value in F329.

    Cross is not always in the same position in relation to smith, that's why I can't use an offset in the code. Thanks!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!