Windows XP Ignoring a date in a lookup value in order to work a VLOOKUP formula

Oct 22, 2008
Reaction score
I would like to use a VLOOKUP formula in my bank statement sheets in order to populate item codes from a lookup table. Some of the entries (lookup values) in a statement contain a date in the form of ddmmm (e.i. 21JUL). Is there a way of creating a VLOOKUP formula that will ignore the date in the lookup value and therefore populate correct item codes into the statement sheets...for example I have several instances of the entry BANK TRANSFER ON ddmmm, where ddmmm is the date (21JUL, 11AUG, 05SEP). I would create a lookup table with a single entry BANK TRANSFER ON and the VLOOKUP formula will recognise this entry ignoring the date in the lookup value.
Hope it makes sense. Thank you in advance. Heidi

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows XP Ignoring formulas 2
Windows XP Append these DNS Suffixes in Order Not working 0
Windows XP Formula not calculating in correct order - please help 0
Windows XP Slow Lookup 2
Windows XP Lookup Functions 2
Windows XP Vlookup question 2
Windows XP If's combined with vlookups 0
Windows XP VLOOKUP Multiple Vaules 1