Hi all,
I want to do a simple index reference lookup, but I'm using this as the lookup value ="1/1/"&YEAR(TODAY()) and it keeps returning an error.
Is there a way to modify the formula? Use a different formula? Reformat my lookup value to comply?
Formula Cell - Q8
Lookup Value Cell- AG3
Thanks guys!
If you change AG20 from 1/01/2016 to 1/1/2016 you'll get a match. It means putting the AG17:Ag23 range in as text. Use the ' symbol then type 1/1/2014 etc down the range
Happy with my advice? Click on the * reputation button below
That formula returns a TEXT string that looks like a date.Originally Posted by Gblack686
This formula will return a real date:
=DATE(YEAR(TODAY()),1,1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Solid solid. Both quality answers that solved my problem. I knew that had something to do with the answer, just didn't know how to remedy it.
Thanks guys!
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks