Excel - Dynamic row reference based on the row I paste a formula into?
- by michaelmichael
I have a simple, oft-used formula that I paste as plain text into spreadsheets I receive. It looks something like this:
=IF(D8="FOO", "BAR", "BAZ")
It looks in D8 for the word "FOO". If it finds it it will show "BAR". If it doesn't it will show "BAZ"
It works great. The problem is I have to paste this formula as plain text into many spreadsheets. It should ALWAYS look in column D for "FOO", however I don't always want it to look in row 8. I'd like it to look at whatever row I'm pasting it into.
For example, if I pasted the above formula into row 25, say, I would like it to automatically change to this:
=IF(D25="FOO", "BAR", "BAZ")
Is there any way to achieve this?