if statement with Vlookup and wildcard

Hello, I use excel a lot. I look forward to posting my question. thank you.

I cant seem to get the below formula to work. I need to know if you can use and if statement that looks at a particular cell (A26) that is equal to a wildcard. Is this possible? I have a table of Terminal IDs that will return a location name. Unfortunately, the terminal ID comes in a file that give the last for numbers as the transaction, therefore, I can't use them when trying to return the terminal location. Thank you for your help.


=IF($A$26="@ ATM Deposit 0492*",VLOOKUP("@ ATM Deposit 0492*",$A$2:$B$18,2,FALSE),IF($A$26="@ ATM Deposit 0494*",VLOOKUP("@ ATM Deposit 0494*",$A$2:$B$18,2,FALSE)))

Hi here Conjohn!

This is the introduction sub forum and those individuals that can help you would most likely not be looking here. If you can create a thread with your question in this sub forum then you would have much better results with getting an answer!

http://www.excelforum.com/excel-formulas-and-functions/