Re: Vlookup With 2 Conditions
If you want a formula in D2 to just find the first row where MATT_INUP!A$2:A$11 = A2 and where MATT_INUP!D$2:D$11 = 0 and return the corresponding value from MATT_INUP!B$2:B$11 then one way, without helper columns, is
confirmed with CTRL+SHIFT+ENTER
edit:....actually that isn't too far from the formula you suggested in your first post, that would work too, except you need to lose the quotes around 0 (because the zeroes aren't text) and the 4 at the end should be a 2 (because you want to return the value from the 2nd column of the range, column B, not the 4th)...so your formula then would be
Last edited by daddylonglegs; June 26th, 2007 at 08:50.
Video Tutorials / Excel Dashboards Reports