if function match

[Haz]

Hi,
I am trying to get an if function that works with a deviation of 5 to
distinguish
between rows from which to get data from Col H.

Example if sheet 1 cell C7 was 81.25% its needs to match this with sheet 2
c22 which is 80 and then get value in H22 and paste this in sheet 1 C6.

Sheet 2 col C goes up in 5, i.e 5,10,15,20 and so on. the match is based
on where c7 fits between a difference of 5.

If c7 was 20 this would match exactly with sheet 2 C10 and then give value
in H10. but this is not always the case. So I guess an if function that works
within a 5 mark principle would then match my col c in sheet 2 and give
value corresponding in Col H.

Any help would be much appreciated.

 

[Max]

Maybe you meant something like this,
In Sheet1, in C6: =VLOOKUP(C7,Sheet2!C:H,6)
Above assumes that the lookup col C in Sheet2 is sorted in ascending order,
with values consistent with the lookup value in C6 (Note that a value of
81.25% is not the same as 81.25).
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik

 

[Pete_UK]

You seem reluctant to try the solutions given to you in your previous
post:

http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/thread/e2f37353b2d788ea#

Note that using VLOOKUP without the 4th parameter enables you to
search for an inexact match (i.e. matches a range of values).

Pete

 

[Dylan @ UAFC]

I though this question was pertiaing to if function.
Max if you can help I have spreedsheet with a very complex
series of vlookup fromulas pull off a data base that is
500,000 deep and about 15 columns out.
The mail data page is set down 25000 rows right now.

It was running good speed was super but efficient.
The whole thing is driven off a phone #, completely unique and
in ascending order.

The problem is that In the main data page can not have duplicate
phone # entry, it tells us a lot, very important to the concept.

I incerted,
=IF(COUNTIF($b$1:$b$25000,a1)>1,"TRUE","FALSE")

now the spreedsheet is so slow it can barly run.any sujjestions