reference from worksheet , partial match and exact match

sleek12

Board Regular
Joined
May 3, 2014
Messages
73
Office Version
  1. 365
Platform
  1. Windows
crossposted from
other forum

NB: am 365 user, have regex feature as well.

i want from this:
askquery.xlsx
ABCDEF
1DATEPAYEECHEQUE NOCHEQUE AMOUNTBANK DEPOSITEDCOMMENTS
204/11/2024IMRAN NAZAK CONDESCENT267010,000KCB MADAGASCARBANKED
307/11/2024CONDESCENT INSURANCE AGENCY2936241,660KCB MADAGASCARBANKED
406/11/2024CONDESCENT INSURANCE AGENCY11026,153KCB MADAGASCARBANKED
511/11/2024CONDESCENT INSURANCE AGENCY284626,151KCB MADAGASCARBANKED
611/11/2024CONDESCENT INSURANCE AGENCY12075,000KCB MADAGASCARBANKED
712/11/2024CONDESCENT INSURANCE AGENCY116152,918KCB MADAGASCARBANKED
819/11/2024CONDESCENT INSURANCE AGENCY136272,989KCB MADAGASCARBANKED
916/11/2024CONDESCENT INSURANCE AGENCY14040,226KCB MADAGASCARBANKED
1015/11/2024CONDESCENT INSURANCE AGENCY13361,749KCB MADAGASCARBANKED
1113/11/2024CONDESCENT INSURANCE AGENCY1449,816KCB MADAGASCARBANKED
1222/11/2024CONDESCENT INSURANCE AGENCY187261,724KCB MADAGASCARBANKED
1303/11/2024CONDESCENT INSURANCE AGENCY182305,416KCB MADAGASCARBANKED
1425/11/2024CONDESCENT INSURANCE AGENCY19568,058KCB MADAGASCARBANKED
1526/11/2024CONDESCENT INSURANCE AGENCY294170,404KCB MADAGASCARBANKED
1630/11/2024CONDESCENT INSURANCE AGENCY293322,466KCB MADAGASCARBANKED
1729/11/2024 by reference to this[/B]
askquery.xlsx
ABCDEFG
1 12.11.2024 14.11.2024 Chq Dep CHQ001991 MARWA BANK0121,859.00 NOTFI24317MT68S
2 12.11.2024 14.11.2024 Chq Dep CHQ002846 MARWA BANK026,151.00 NOTFI24317N1Q47
3 12.11.2024 14.11.2024 Chq Dep CHQ000116 MARWA BANK0152,918.00 NOTFI2431755P1B
4 12.11.2024 14.11.2024 Chq Dep CHQ000120 MARWA BANK075,000.00 NOTFI24317TQZQ3
5 12.11.2024 14.11.2024 Chq Dep CHQ001990 MARWA BANK0191,500.00 NOTFI243176Z8H4
6 12.11.2024 14.11.2024 Chq Dep CHQ000041 JOHN BANK039,870.00 NOTFI24317RQKCV
7 12.11.2024 14.11.2024 Chq Dep CHQ000404 JOHN BANK0150,000.00 NOTFI243179FGG0
8 12.11.2024 14.11.2024 Chq Dep CHQ000165 CONSOLATA BANK050,000.00 NOTFI24317ZPKP6
9 12.11.2024 14.11.2024 Chq Dep CHQ000456 CONSOLATA BANK010,159.00 NOTFI24317VDBTB
10 12.11.2024 12.11.2024 Pesalink Incomi 2024111209525370 NCBA Insurance Premium Declaration KCB BANK098,931.00 NOTFI24317VBFZX
11 14.11.2024 14.11.2024 INXYZuse CHQ054996 CRATER VIEW AUCTIONXERS-60,000.000 NOTFI243194JWWC
12 14.11.2024 14.11.2024 INXYZuse CHQ056823 PETER CHEGE WAMAITHA-15,000.000 NOTFI24319SY39Q
13 14.11.2024 14.11.2024 INXYZuse CHQ056959 KEVIN ONYANGO OWITI-30,000.000 NOTFI24319QFKTX
14 14.11.2024 14.11.2024 INXYZuse CHQ056698 XYZRAGON PROPERTY CONSULTANTS LTD-38,233.000 NOTFI243197ZBK0
15 14.11.2024 14.11.2024 INXYZuse CHQ056928 MAURICE ODERA ONGURU-40,000.000 NOTFI243193H1G8
16 19.11.2024 21.11.2024 Chq Dep CHQ002004 acme BANK0158,000.00 NOTFI24324P5M80
17 19.11.2024 21.11.2024 Chq Dep CHQ000136 acme BANK0272,989.00 NOTFI243246M0ND
18 19.11.2024 19.11.2024 Pesalink Incomi 20241119100830fc NCBA Insurance Premium Declaration KCB BANK0198,365.00 NOTFI24324H7D2Q
referbankstatement
to get this result
askquery.xlsx
HIJK
5 12.11.2024 14.11.2024 Chq Dep CHQ002846 MARWA BANK26,151.00
6 12.11.2024 14.11.2024 Chq Dep CHQ000120 MARWA BANK75,000.00
7 12.11.2024 14.11.2024 Chq Dep CHQ000116 MARWA BANK152,918.00
8 19.11.2024 21.11.2024 Chq Dep CHQ000136 acme BANK272,989.00
query
query
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,225,730
Messages
6,186,698
Members
453,369
Latest member
positivemind

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