Article added on Monday, 10 June 2019

SPREADSHEETS

VLOOKUP wildcards

You’re using Excel to tie up cheque payments with a list of cleared transactions from the bank. The problem is that the cheque number on the bank’s record is embedded in the transaction code. How can you use VLOOKUP to match it?

Login

Username
Password Remember [?]

Forgotten your Username/Password?

Subscribe

Access to this part of tipsandadvice-financialcontroller.co.​uk is only available to subscribers.


Don't have a subscription?
Subscribe now for immediate access to the digital version of all the articles.


Subscribe

© Indicator - FL Memo Ltd • Telephone: (01233) 653500 • Fax: (01233) 647100 • customer.services@indicator-flm.co.uk • www.indicator-flm.co.uk
Calgarth House, 39-41 Bank Street, Ashford, Kent TN23 1DQ • VAT GB 726 598 394 • Registered in England • Company Registration No. 3599719

Last Updated: 03.07.2020

More from Indicator - FL Memo Ltd