derek davis
Member
Hi everyone, I knocked a simple Lookup but when I make selection in G11 I can get the correct answer and a error #N/A depending on my selection. I dont know why this is happening.
I tried also to format 3B-3E as a custom date which should display the year only. This is returning 1905? My reason for this particular format is I would like to get the lookup to only look for the current year. This would save me having to make aleration to the lookup formula in the future. I am not sure if lookup can handle this?
Any help would be most appreciated.
I tried also to format 3B-3E as a custom date which should display the year only. This is returning 1905? My reason for this particular format is I would like to get the lookup to only look for the current year. This would save me having to make aleration to the lookup formula in the future. I am not sure if lookup can handle this?
Any help would be most appreciated.