Do you want to always keep one of the columns in your formula absolute and not change it? So if you wanted to always look at A9, you can change the A9 in the formula to be $A$9.
Post by NothingWrongwithOhio on Mar 31, 2015 10:26:27 GMT -5
Nvm, I was wrong, can't do multiple columns as the requirement or the range that way.
Maybe this is an asshole question, but why are they on separate sheets? Why not put all the data on one sheet (with a month or date column) and then you could make a pivot table and it would be easy to get info?
Post by JayhawkGirl on Mar 31, 2015 10:45:26 GMT -5
I'm admittedly half awake, but I think VLookup will do what you want. Basically VLookup go find this data (name) over here (other tab, other area of data) and return the data point found in column #.
Yup, you have to use a vlookup within the if/then statement.
ETA: It's probably hard to "describe" writing the formula. I love Excel stuff - if you have dummy data and want to PM I can write it for you. That might be creepy, so take it or leave it I'm just an Excel nerd.
Post by trafficgirl on Mar 31, 2015 11:33:39 GMT -5
I agree with bearbaby - you need a nested vlookup function in the if/then function. Unfortunately I'm not super great with those. I would need the spreadsheet to try and figure it out - not saying you should sent it to me!