# Step by Step Creation.

L

#### Legacy 23340

##### Guest
hi all,

I give preference to IF statements for this purpose.

Here is what I am trying to do.

I have 2 values in cells G11 and G12 which I match to values in cells L11 to L38 they are matched with a tolerance value that is stated in cell G7.

This is easy I was able to do this already where the cells are highlighted by conditional formatting.

What I now want to do is this.

I have 4 free cells which are cells B28 and B29 and C28 and C29.

If any values from L11-L38 match any value from G11 within the tolerance limit of G7 then those matching values would be copied (not cut) or displayed to fill the cells B28 and B29.

And if any values from L11-L38 match any value from G12 within the tolerance limit of G7 then those 2 matching values would be copied as above or displayed to fill in cells C28 and C29.

if this works then i can get rid ofthe conditional formatting that is there as what happens is that sometimes the highlighted cells are all over the columns and i have to sort them visually in order which is a big chore.

I would like to have step by step instructions on how to do this.

thanks,
water.

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
i just saw something on h lookup function can this work? only that i need to output those 2 matching cells to C28-29 and C28-29

i would appreciate some help on my matter folks

thanks

water

I'm sorry, maybe it's just me, but I'm having trouble picturing your problem.

Can you post an example of your data and required result, perhaps using Colo's HTML Maker?

i can;t use colo maker because i am using proprietary equations but i can surely give examples using figures,

The values
1)

\$G\$11= 12066
\$G\$12= 11570

2) \$L\$11-\$L\$38

12082
12059
12036
12013
11990
11967
11944
11921
11898
11875
11852
11829
11806
11783
11760
11737
11714
11691
11668
11645
11622
11599
11576
11553
11530
11507
11484
11461

3) \$G\$7 = 23

So now 12066 = in which 12082 and 12059 are within 23 of 12066

Same goes for 11570 11576, 11553 are within 23 of 11570

the valid figures should populate cells B33-34 for 12082 and 12059

and C33-34 for 11576 and 11553.

values change everytime i update the sheet.

hope this helps.

Replies
0
Views
258
Replies
0
Views
206
Replies
0
Views
884
Replies
6
Views
917
Replies
7
Views
392

1,221,506
Messages
6,160,205
Members
451,630
Latest member
zxhathust

### 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.

### Which adblocker are you using?

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

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