Matching 2 values where one of the values is obtained using a formula

B

bat18

Board Regular
Joined
Mar 29, 2010
Messages
89
I'm not sure why but when using this formula

=IF(U2<>"", MATCH(U2,R:R, 0), "")

to try and match a value that is typed into cell U2 with the same value that is obtained somewhere in column R with the formula

=IF(M2<>"", SUMIF(C:C, C2,M:M ), "")

doesn't work. It only matches the values if i copy column R and paste values. Any ideas anyone??
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Sort by date Sort by votes
It could be format. Sometimes if the number is derived from a different system, this can happen.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Solved
Ranking Riddle
2
Replies
14
Views
798
Fluff
Fluff
B
  • Question
When is a number not a number? Match() does not recognize number.
Replies
7
Views
556
Tupe77
T
A
  • Question
Lookup value based on multiple criteria where one is searching a cell for specific text string
Replies
0
Views
292
alex0182828
A
O
  • Question
Vlookup() and Index(Match()) returning N/A, even though the lookup value exists in the range and is identical to that value within the range.
Replies
6
Views
1K
nemmi69
nemmi69
L
  • Solved
Formula to return the value of the duplicate number
Replies
3
Views
387
kevin9999
K

Forum statistics

Threads
1,215,525
Messages
6,125,325
Members
449,218
Latest member
Excel Master

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top