I'm trying to look at multiple criteria on one sheet and return the value (date) from that row. I'm having the hardest time for some reason. Basically, explained below and I've attached a spreadsheet too.
I want to know if A2=Column A in sharepoint tab and $b$1=Column C in sharepoint tab, return the value from Sharepoint tab Column F to Cell B2. Need this for all columns and rows.
All help would be greatly appreciated!
Bookmarks