So I am trying to pull data f
So I am trying to pull data f
Last edited by phasesmu; 03-20-2014 at 08:40 AM.
By the way, I only have Excel 2003.
Maybe this one?
I amn not sure actually
Sheet1 J2 cell
=IF(ISERROR(INDEX(Sheet3!$A$1:$A$217,MATCH(1,(B2=Sheet3!$B$1:$B$217)*(Sheet1!C2=Sheet3!$C$1:$C$217)*(D2=Sheet3!$E$1:$E$217)*(Sheet1!F2=Sheet3!$D$1:$D$217)*(Sheet1!H2=Sheet3!$G$1:$G$217)*(Sheet1!I2=Sheet3!$H$1:$H$217),0))),"",INDEX(Sheet3!$A$1:$A$217,MATCH(1,(B2=Sheet3!$B$1:$B$217)*(Sheet1!C2=Sheet3!$C$1:$C$217)*(D2=Sheet3!$E$1:$E$217)*(Sheet1!F2=Sheet3!$D$1:$D$217)*(Sheet1!H2=Sheet3!$G$1:$G$217)*(Sheet1!I2=Sheet3!$H$1:$H$217),0)))
Hit ctrl+shift+enter after pasting
Appreciate the help? CLICK *
Unfortunately, that didn't work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks