A1 has ref numbers
B1 has ref numbers
c1 has amount paid.
So if a1 matches the ref number in b1 then paste in e1 the total amount paid which will be in c1 if it does not match then leave it blank..
A1 has ref numbers
B1 has ref numbers
c1 has amount paid.
So if a1 matches the ref number in b1 then paste in e1 the total amount paid which will be in c1 if it does not match then leave it blank..
In E1 type = if(A1 = B1, C1, " ")
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks