I need to pull a number from a column (Week #) but it has to match up with criteria from 3 other columns.
1. Week (A:A) (column to pull from) 2. Code (B:B)(Criteria) 3. Year(C:C) (Criteria) 4. Occupancy (D:D) (Criteria).
The code column has alphabetical input, such as CCC. The year column data is represented in terms of 2014 and the occupancy column is represented as in terms of 0.60, for example. B:B and C:C have to be exact matches but D:D needs to be in the MATCH form of "-1" (smallest value that is greater than or equal to the lookup value.) This is because D:D often does not have the exact number needed in the data set its being pulled from and the point of this is to be able to frequently swap out values to autofill a table. I need a function that will reference all 3 things and when they are all true, generate a number from column A:A.
Thanks!
Bookmarks