LinkBack URL
About LinkBacks
BlakeLee 
I think you should use sth like this:
In P2:
Confirmed by holding both Ctrl-Shift, then Enter.
=INDEX('code list'!H$2:H$11,MATCH(1,('code list'!$E$2:$E$11=$V2)*('code list'!$G$2:$G$11>=query!$W2),0))
Drag down and copy to Cost column
I think you should use sth like this:
In P2:
Confirmed by holding both Ctrl-Shift, then Enter.=INDEX('code list'!H$2:H$11,MATCH(1,('code list'!$E$2:$E$11=$V2)*('code list'!$G$2:$G$11>=query!$W2),0))
Drag down and copy to Cost column
Quang PT
thank you,
index/match = much appreciated.
sitting here going through your formula, learned more from your formula than I did searching match/index on line for 4 hrs.
bye-bye vlookup, hello, index, match.
So, not only have you saved me many hrs, processing these sheets; I think you've given me a way to adjust other vlookup formulas I've been using on other sheets.
I'm going to start calling this site 'browes & learn'
thanks you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks