multi-variable lookup across ranges

Brass Contributor

incorrectly posted first time.  reposting with adjusted data.

1 Reply
Ensure the accuracy of your data. You forgot to edit the 3rd range. The column labels are not dates. Also, you forgot to edit your lookup parameter. It should be expressed as date rather than text.