LinkBack URL
About LinkBacks
Like this...
=IF(O7=INDEX($D13:$D100,COLUMNS($A1:A1)),IF(INDEX($F13:$F100,COLUMNS($A1:A1))="successful","Successful Discovery Well","Unsuccessful Discovery Well"),"No Drill")
Adjust for the end of ranges where I use down to D100 and F100.
Like this...
=IF(O7=INDEX($D13:$D100,COLUMNS($A1:A1)),IF(INDEX($F13:$F100,COLUMNS($A1:A1))="successful","Successful Discovery Well","Unsuccessful Discovery Well"),"No Drill")
Adjust for the end of ranges where I use down to D100 and F100.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks