Formula to see if a value is in a range

1. Formula to see if a value is in a range

Hello everyone,

I'm looking for a formula to see if a value of one cell lies within the values of two other cells, and then based on the value of a third column, make new rows with the corresponding third column value...

``Please Login or Register  to view this content.``
But would it be possible to make:
``Please Login or Register  to view this content.``
Sorry for the mess, I don't know how to work the table function in this forum format!

Worksheet Formulas
Cell Formula
A2 =IF(ROWS(D\$2:D2)<=(MAX(B:B)-MIN(A:A)+1),MIN(A:A)+COUNT(D\$1:D1),"")
B2 =IF(LEN(D2),D2+1,"")
C2 =IF(LEN(D2),LOOKUP(D2,A:A,C:C),"")

But it does not account for decimals.

Would it be possible to have text generated that is a mix of the two values in column c if there are decimals?

Thanks,

BobFrank01

2. Re: Formula to see if a value is in a range

Hi Bobfrank,

Any chance you could upload a sample workbook showing what you are trying to accomplish? I'm having a bit of trouble following your example.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1