IF Function not working with list

[xtraman88]

Hi i need help on getting a outcome (date) from data in worksheet i have tried IF function but will not work with lists

Column 1: Inputted Characters
Column 2: List of all possible inputted characters
Column 3: List of dates to match inputted characters
Column 4: Outcome
http://www.excelforum.com/excel-gene...ml#post3518578

[FDibbins]

Thanks for the title change

Could you explain in more detail what you are working with, and what your outcome should be? Perhaps upload a sample workbook?

[xtraman88]

Hi I have attached workbook
Column A is the data I am receiving
Column B gets me the last two characters which I need
Column C is where i want my outcome
Column D is the list of possible outcomes of column B
Column E is the list of dates corresponding with Column D
I still have a lot of data to add to column D

The idea is that by adding a number to column A it will return the correct date in column C

Thanks very much for you help so far
regards
Steve

[FDibbins]

maybe this?

=VLOOKUP(B2*1,$D$2:$E$407,2,0)

[mehmetcik]

Hi

Your basic problem was that although column D looks like two characters it wasn't. It was simply formatted to look like two characters.

My Column E made it two characters. I copied and pasted the values into column D.

[xtraman88]

maybe this?

=VLOOKUP(B2*1,$D$2:$E$407,2,0)

Works perfectly thank you very much for help

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)