Thread: [Solved] Excel Formula
View Single Post
 
Old 02-28-2012, 07:48 PM
JBeaucaire JBeaucaire is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

1) On sheet1, put this formula in D1, then copy down... you will get errors on the non-matches....

=INDEX(Sheet2!$C$1:$C$200, MATCH($B1&"-"&$C1, INDEX(Sheet2!$A$1:$A$200&"-"&Sheet2!$B$1:$B$200, 0), 0))

2) Copy that column

3) Do an Edit > Paste Special > Values to remove the formulas

4) With the data still highlighted, press F5 and click on Special

5) Select Constants > Errors > OK

6) Press DELETE and the error cells will be gone.
Reply With Quote