Lookup value in colA whos row matches row of index value in colB

A

Aladin Akyurek

Gwen,

Replace the formula in E50 in the system I posted with:

=MAX(IF(INDEX(B52:B59,MATCH(E49,C52:C59,0))=B52:B59,C52:C59))-E49

which must be confirmed with control+shift+enter instead of just wit
enter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count # items in ColA if blank in ColB 11
Finding the largest match 9
Lookup value in colA whos row matches row of index value in colB 3
Compare two files and update data from another file base on words ina cell separated by commas 0
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
Looking up the value corresponding to the last repetition in a ran 1
lookup value if multiple matches are met 2
Index Match & #values 0

Top