Some questions for You:
What would You vlookup?
... there could find same values from 'Bank Statement's E-column and 'Bank Ledger's F-column ... hmm? Lookup
Why 'Bank Statement's Value Dates have ' in front of date?
Have You checked vlookup's syntax?
eg > https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
Have You checked vlookup with "*"?
eg > https://exceljet.net/formula/partial-match-with-vlookup
=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 ?
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'.
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)
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.