hi i need to find the value in D2 in D5:D87 then pull the value that is in column A. so for the attached, i need a formula D1 that would retrieve the value in A87.
i would then need to copy D1 across so that each column's lowest value has the column a coordinate. i tried to figure out how to use MATCH, INDEX, and LOOKUP, but haven't used those functions before and am having trouble.
Thanks in advance for any assistance.
Bookmarks