LinkBack URL
About LinkBacks
B6:committed with Ctrl-Shift-Enter rather than just Enter as this is an Array FormulaFormula:
=INDEX(K$2:K$39,MATCH($B$2&$A6,$I$2:$I$39&$J$2:$J$39,0))
Regards, TMS
B6:committed with Ctrl-Shift-Enter rather than just Enter as this is an Array FormulaFormula:=INDEX(K$2:K$39,MATCH($B$2&$A6,$I$2:$I$39&$J$2:$J$39,0))
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks TMS
When I copy the formula & paste in the cell A6, it give me 0. But is should give me 19233 as that is the Lease ID. Can you please advise?
Thanks & Regards
Arpan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks