Match value from range to data

[T15K]

Hello,

I am would like some assistance with a formula that checks which range a certain number falls (located in Col A) within, and then adds a value corresponding to the range in the column next to the original number (Col B).

I have attached an example spreadsheet which should make things clearer. The data in Col A extends down about 2500 rows, and there is approximately 150 different ranges that the data can fall into.

I thank you in advance for your assistance

T15K

[Fotis1991]

Hi

try

Please Login or Register  to view this content.

[benishiryo]

@Fotis:
you mean:
=LOOKUP(A2,$D$2:$D$11,$F$2:$F$11)

[T15K]

Perfect. Thank You!!1

[T15K]

PS @Fotis, I am trying to add to you reputation, but it wont let me, it says that I need to share it around before I can do it again?

[T15K]

The reputation just worked then....

[Fotis1991]

@Fotis:
you mean:
=LOOKUP(A2,$D$2:$D$11,$F$2:$F$11)

Thanks my friend!!

@ T15K

You are welcome and thanks for the feedback!

No worries. You gave to me a rep and thanks for that!