G Guest Sep 6, 2007 #1 How do I match a cell from one sheet to another and then in a different sheet I would like only the matched cells displayed?
How do I match a cell from one sheet to another and then in a different sheet I would like only the matched cells displayed?
G Guest Sep 7, 2007 #2 petester said: How do I match a cell from one sheet to another and then in a different sheet I would like only the matched cells displayed? Click to expand... Suggest that you browse Debra's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study ---
petester said: How do I match a cell from one sheet to another and then in a different sheet I would like only the matched cells displayed? Click to expand... Suggest that you browse Debra's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study ---
