How to extract matching values

Microsoft Excel 2007 home and student
March 11, 2010 at 07:59:52
Specs: Windows XP
I have a spread sheet from which I want to extract values if certain associations between columns are met.

If a specific condition is found in column A/spreadsheet1:

1) Extract it to Column A in spreadsheet 2

2) Extract the corresponding value on the same row of column B in spreadsheet 1 and paste it in column B in spreadsheet 2

Hope you guys can help


See More: How to extract matching values

March 11, 2010 at 08:04:30
Since there are multiple ways to accomplish your goal, it would help if you told us what types of "condition" we're dealing with.

The answer could range from simple conditions that can be handled with some sort of IF statement to complex conditions that require VBA.

The more detail you provide, the more complete a solution we can offer.

Report •
Related Solutions

Ask Question