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.
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
L

Legacy 23340

Guest
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
 
L

Legacy 23340

Guest
i would appreciate some help on my matter folks

thanks

water
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,059
Office Version
  1. 365
Platform
  1. Windows
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?
 
L

Legacy 23340

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

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,680
Members
412,481
Latest member
nhantam
Top