I am looking for some assistance with a formula in Excel.
I have a table which consists of text, numbers and date in each of the columns, which I have set out below.
Column A Column B Column C
30/2/13 1000 Yes
What I am looking to do is to return the date for the corresponding yes appears using VLOOKUP(Yes,A1:C5,1,FALSE)
However i receive the value #N/A
Is there an error in the method I am using or is there a better formula to use to return the information that I am looking for.
Thanks
Bookmarks