Copy cells from column B if cells in column A matches criteria

giovi321

New Member
Joined
Jun 26, 2017
Messages
6
Hello everybody,
I am new to Mr.Excel and to VBA scripting. Thank you in advance for anybody who can help.
I have a table with multiple columns. I would like to copy from that table the column A to a certain range in another sheet if the cells in columns B and C match certain criterias.
Input
A
B
C
x
0,2
11
y
0,4
20
z
3
11

<tbody>
</tbody>

Criterias: B<1 AND C>10

Expected output:
A
x
y

<tbody>
</tbody>

I tried several codes taken mostly from Mr.Excel, but couldn't get any success.

Thank you again to anybody who can help!
 
I will try to explain better: the values of the column B in the sheet named input (what i have called input sheet) vary depending on the values of column C in the sheet named output (indirectly through a index match from another sheet).
This will create a circular reference.
I know... and I do not know how to handle such a circular reference.
 
Upvote 0

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,216,452
Messages
6,130,721
Members
449,588
Latest member
ahmed Adel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top