I have a really simple question for someone that uses excel regularly...
I have a data (Data) sheet and a report generation sheet (Report).
I'd like to grab a cell value from the data sheet and place it in the formula cell on the report generation sheet.
I'd like a formula that says basically:
If Data!Date = A5 & Data!Channel = "Online" & Data!Score = "400" then return Data!Decision
Data!Decision could be yes, or no, or a number. Basically, I just want to reutrn the coresponding cell for a given Data, Channel, and Score...
Thanks in advance!
EDIT to model the tables for better help and suggestions:
Date Channel Score Decision 9/9/14 Online 400 7 10/2/14 TV 400 5
Report Table (this table is only for Online and Score = 400)
Date Decision 9/9/14
I'd like the value of 7 to be returned in that empty cell in the Report Table, thus the formula should take into account Channel = "Online" and Score = 400