I have this formula in cell Q3: =VLOOKUP(R3,'Revenue Name'!$A$2:$B$700,2,0) It works.
I need to modify it so it's looking in a tab named Membership and is looking in column D $D2:$D700 for the value in R3
=VLOOKUP(R3,'Membership'!$D$2:$D$700,2,0) but this produces a #REF error. I believe the issue is with the "2" in this formula and have changed it to 13 (13 being the difference between D and Q) and get the same #REF. I've changed it to -13 and now get a #VALUE error.
Any direction would be appreciated.
Thanks in advance
I need to modify it so it's looking in a tab named Membership and is looking in column D $D2:$D700 for the value in R3
=VLOOKUP(R3,'Membership'!$D$2:$D$700,2,0) but this produces a #REF error. I believe the issue is with the "2" in this formula and have changed it to 13 (13 being the difference between D and Q) and get the same #REF. I've changed it to -13 and now get a #VALUE error.
Any direction would be appreciated.
Thanks in advance