Vlookup question



Good afternoon,
I am using EXCEL 2007

I have 2 workbooks (see below) and would like to use a function to extract
and show only the suffix of a file name either pdf or xlsm from book 1 to
book 2. I have vlookup now but do not know how to get only the suffix of
the file name. Is there a way to get only the "pdf" or "xlsm" by using
vlookup? I am open to using any function if there is one better.

Thanks in advance.


Book 1
123 123.xlsm
456 456.pdf

Book 2
456 pdf
123 .xlsm

Current Function:



T. Valko

**Maybe** this:


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