Forum menu
Hi,
I'm new to the more complex side of Excel (complex to me) and I need help with a formula! I need to take two values (cells D7 and E7) then use these to look up a price on another sheet. D7 corresponds to a value in column A and E7 corresponds to a value on Row 2, I need to get the value from the cell where these two intersect... Please help as I'm getting confused with Index Match and arrays!
As usual, a flavour of v-lookup is what you need.
Thanks, the example by somouk is what I need but the two values are variable which is where I need the help I'm afraid!
use MATCH and INDEX and if necessary INDIRECT
Or MATCH and OFFSET
Or... our old friend Sumproduct()
*wipes tear from a wistful eye*
We'll always have SUMPRODUCT, Rob.
Happier times them good old days!
We were young, our hearts were open books. Letting live etc.
Not an inckling that Google Sheets was the future...
Sorted it with an OFFSET MATCH MATCH, thanks all!