Forum Discussion
Need assistance with formula
Hi All, Still pretty new to the formula side of excel and need assistance with coming up with one for this situation. Essentially I need to pull the the cell from column D (HOURS) as long as it m...
I gave both formulas you provided a shot and couldn't get either to function. Both lines where I saw that you had a "V4" I tried as a V4 and a V3 but neither was a go. I am having trouble narrowing down what I'm putting in, incorrectly. Thank you for your time with helping.
BTW I'm using office professional plus 2016
The account name is actually in cell V3. My mistake when i transferred the data into my sheet.
=INDEX(HOURS!$D:$D,MATCH(1,(HOURS!$A:$A=$B$1)*(HOURS!$B:$B=A5)*(HOURS!$E:$E=$V$3),0))This formula works in the attached file.
I work with Excel 2013 and therefore have to enter the formula with ctrl+shift+enter (CSE). With Excel 2016 Pro Plus you have to confirm the formula with CSE as well.
- What is VERGLEICH?
- VERGLEICH in german Excel which is MATCH in english Excel and ПОИСКПОЗ in russian Excel and COINCIDIR in spanish Excel....
Ok so the cell accepted the formula but is not reading it properly. "Value Not Availble Error".