Modify VLOOKUP

[RodneyC]

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

 

[Fluff]

What column do you need to return the value from?

 

[RodneyC]

What column do you need to return the value from?

Column D I think I see part of the problem. The value in R3 would be found in column C of Membership I've modified the formula to say this: =VLOOKUP(R3,Membership!$C$2:$D$700,-13,0) and still get a #VALUE error

 

[Fluff]

So you want the formula to return the same value that is in R3?

 

[rwmill9716]

The problem is that in the formula that works you have data in cols A & B of which you're grabing data from the B column (where the 2 comes in). In the new formula you just have data in Column D so 2 should be changed to 1.

 

[Fluff]

In the new formula you just have data in Column D so 2 should be changed to 1.

That assumes the OP wants to return the same value as is being looked-up, which seems pretty pointless.

 

[RodneyC]

Here's what I am trying to do... I want to start with looking at the value in R3. From there I want to look for that value in Membership D2:D700. If it finds it, display the value in Membership C2:C700

 

[Fluff]

Ok, how about

=INDEX(Membership!$C$2:$C$700,MATCH(R3,Membership!$D$2:$D$700,0))

 

[RodneyC]

Ok, how about

=INDEX(Membership!$C$2:$C$700,MATCH(R3,Membership!$D$2:$D$700,0))

That's working. Thank you for your help and patience with me.

 

[Fluff]

You're welcome & thanks for the feedback.