Dear sir,
How can I apply wildcard vlookup for attached sheet in bank statement .
How can I apply wildcard vlookup for attached sheet in bank statement .
Attachments

9.6 KB Views: 6
Dear Sir,Shabbo
Some questions for You:
What would You vlookup?
... there could find same values from 'Bank Statement's Ecolumn and 'Bank Ledger's Fcolumn ... hmm? Lookup
Why 'Bank Statement's Value Dates have ' in front of date?
Have You checked vlookup's syntax?
eg > https://support.office.com/enus/article/vlookupfunction0bbc808326fe49638ab893a18ad188a1
Have You checked vlookup with "*"?
eg > https://exceljet.net/formula/partialmatchwithvlookup
Dear Sir,Shabbo
Yes...
Did You noticed that I tried to ask few questions? ( Sentences which ends with ? )
... including two links ... which ... seems You've skipped.
Would You read those links and after You've read and tested those, ask again if needed?
Dear Sir,Shabbo
=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
What is You 'What you want to look up'?
... You have written the whole column with * ... hmm?
Do You really would like to ... look up ... the whole column ?
Dear SirShabbo
Yes ... I would forget term 'VLOOKUP' ...
How do You do it 'manually'? ( = without computer keyboard )
Of course, You could 'see' which 'part' You would try to find from other sheet ...
If You could write a formula to get that 'part' from 'full Narration' then You could use that as 'manually'.
Otherwise ... could You do it opposite way?
You have 'only reference number' ... You could use that to find it from 'full Narration'.
Dear sir,Shabbo
As I tried to explain ...
Try to find out something same as You could do it manually!
Is there any clear rule  which part is that 'reference number'?
... You've asked many times about these.
If there is not any clear rule
... then as I also tried to write
> Otherwise ... could You do it opposite way?
> You have 'only reference number' ... You could use that to find it from 'full Narration'.
Thank you so much sir.Following can be one formula approach. In cell F2 implement following formula
=LOOKUP(2^15,SEARCH('Bank Ledger'!$E$2:$E$4,'Bank Statement'!C2,1),'Bank Ledger'!$F$2:$F$4)
Copy down.
Note that the results in the third cell won't match as in one cell is having "R52019040272121945" and "R5201904027212194500" where the leading zeroes cause mismatch!
Thank you so much sir.Shabbo
Sure ...
but I would solve Your case as I wrote ... and ... 'my way'
Press [ Do It ]
Ps. No matter, how many rows You would have ... keep same layout.
Ps2 ... actually, You might only need to find out differences ... then no need to compare those values manually