Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy row based on match and multiple criteria
Hi all.
I need a formula or function that would look at a value in a cell, compare it to a whole column on another sheet If a match exists then I need the code to look say 10 columns further along in the same row at the cell value. If this value is equal to say "blue" then I want the whole row to be copied to the sheet "Blue" if the value is say "red" then I want the whole row to be copied to sheet red. If no match is found then nothing should happen. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy multiple records based on criteria or total amount | Excel Discussion (Misc queries) | |||
index/match, based on more than one criteria | Excel Discussion (Misc queries) | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Index/Match - Lookup based on multiple column criteria | Excel Worksheet Functions |