Hi,
I wonder if someone can help working out a lookup problem I'm having.
There are two criteria forming the lookup, a date and a text value. The lookup data range is formatted:
Col A / Col B / Col C / Col D / Col E
Start Date / End Date / Text value / Text value / Text value (...)
So if the date I want to find falls between the start date and the end date, and the text value appears in the same row, I want to return "YES".
I've attached a sample spreadsheet which might explain better what I'm looking for.
Thanks.
Bert
Bookmarks