Forum Discussion
copy cell
Hi all
Have small issue
I need to copy information to different cell if the number from A column is the same as in other spreadsheet and bring all the cells in row B to another row
I tried VLOOKUP but its keep bringing just the first value
12 Replies
The new FILTER function should work, if I understand what you're asking. That is available in the newest versions of Excel. Here's a reference site that can help you with the syntax for your own situation. If you need further help, please attach a copy of your actual spreadsheet rather than just an image.
https://exceljet.net/excel-functions/excel-filter-function
Just quick question in example its just red and blue
What example are you referring to? The one that started this chain? Or a purely hypothetical/imaginary one?
What if i have more criteria then 2 lets just say I have red , blue , black and white
how would i get to show all black and white
I presume you mean only black and white; stated another way, what you mean is "I have four conditions, red, blue, black and white" and you want to select rows meeting two criteria, satisfying either or two conditions. You do that, using filter, by using something like the following for the criteria section within the FILTER function. (CellRange="black")*(CellRange="white)
hope you understood the question
I hope so too. If not, please come back and clarify. Even better, attach a working sample spreadsheet. It's always easier to work with something closely resembling what one is asking about.
- Thank You
its perfect for what i need
