Still need help with address and matching function

[flipit]

Hello Friends,

Im using windows vista with excel 2007.

I have a list of phone numbers in column C and the last four digits to those phone numbers in column B in descending order. Im looking for a function that would give me the address of my partial number in column B that is in column C?

I have used this before to find the whole number but now just want to get the same result with only using the last four digits. The below code is not working?

=ADDRESS(MATCH(B2,$C$1:$C$501,0),COLUMN($C$1:$C$501))

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 143"]
<tbody>[TR]
[TD="class: xl65, width: 143"]FORMULA[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="class: xl65, width: 168"]DNC NUMBER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206"]Phone[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="width: 168, align: right"]3986[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206, align: right"]2104903722[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="width: 168, align: right"]2787[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206, align: right"]5625972787[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="width: 168, align: right"]3722[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206, align: right"]5628093986[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="width: 168, align: right"]3084[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206, align: right"]5629233084

[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206, align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206, align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 801"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]please help [/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

 

[gehusi]

Try this...

{=ADDRESS(MATCH(B1,RIGHT($C$1:$C$501,4),0),3,1,1)}

Enter with Ctrl+Shift+Enter.

If you have the actual values in column B, and not a formula then use this:

{=ADDRESS(MATCH(TEXT(B1,"####"),RIGHT($C$1:$C$501,4),0),3,1,1)}

Again, Ctrl+Shift+Enter.

 

[flipit]

OMG thank you so much it effn worked! your a genius

dude i owe you a beer or whatever ur into LOL

 

[gehusi]

No problem, happy to help.