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!