=VLOOKUP(D2,'Download Data Page'!A2:P2300,16,FALSE)
This current formula does not allow me to chose a second criteria.
1. Criteria 1 look up city name in column A.
2. Criteria 2 look up date & time in column B.
3. Find the conditions in column P.
Is there a way to add a 2nd criteria to VLookup?
Thanks
I usually use the Chandoo "trick" from here: https://chandoo.org/wp/multi-condition-vlookup/
That would make your formula in D4:
Entered with Ctrl+Shift+Enter to create an array formula. Similar across the table. See attached where I had to change some of the data to get sensible results.
Please Login or Register to view this content.
WBD
Office 365 on Windows 11, looking for ✶ rep!
Maybe:
Formula:
Please Login or Register to view this content.
Entered with Ctrl+Shift+Enter.
Good luck!
The formula works nice but when I put it into my spreadsheet it keeps the link to my C drive. How do I break that link?
=VLOOKUP(D$2&$B6,CHOOSE({1,2},'C:\Users\mbrey\Downloads\[TestForecast 2.xlsx]Download Data Page'!$A$2:$A$3100&'C:\Users\mbrey\Downloads\[TestForecast 2.xlsx]Download Data Page'!$B$2:$B$3100,'C:\Users\mbrey\Downloads\[TestForecast 2.xlsx]Download Data Page'!$P$2:$P$3100),2,0)
Either:
1. Remove all the instances of "C:\Users\mbrey\Downloads\[TestForecast 2.xlsx]" from the formula
or
2. Just copy the formula from post #2 and paste it into your sheet
WBD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks