LinkBack URL
About LinkBacks
hassan khansa 
in A2, use
=IFERROR(MAX(IF(VLOOKUP($A$1,$A$4:$J$12,COLUMN($A$4:$J$4),FALSE)<>"",COLUMN($A$4:$J$4))),"Out of Area")
And change all the other formulas from
=OLDFormula
to
=IFERROR(OldFormula,"Out of Area")
in A2, use
=IFERROR(MAX(IF(VLOOKUP($A$1,$A$4:$J$12,COLUMN($A$4:$J$4),FALSE)<>"",COLUMN($A$4:$J$4))),"Out of Area")
And change all the other formulas from
=OLDFormula
to
=IFERROR(OldFormula,"Out of Area")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks