Formula Issue regarding referenced cells

[jdiamond13]

Hey,

So i created an if-then statement in Excel which happens to be in various columns (going horizontally). The data it depends on is going vertically. Since the spreadsheet is so big I wanted to be able to click and drag across. I'm sure some of you see where the issue is already. As I drag horizontally - the data that the cells depend on also go horizontally. The formula is as follows " =IF(O7=D13,IF(F13="successful","Successful Discovery Well", "Unsuccessful Discovery Well"), "No Drill")" I want O7 to turn into P7. That is fine. But i want D13 to turn into D14 and F13 to turn into F14 as I drag horizontally. Is there anyway to accomplish this? Using mixed or absolute reference has not had any help. Thank you

[Tony Valko]

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.