Searching / Vlookup

[asadlone]

Hi all,

I am trying to use the functionality of vloopkup inorder to return the value in the column but am not quite sure whether it would work or not.

I want to search a value along the column

1 100 A
101 200 B
201 300 C

What i want is that if i want to search for 150, it should return the value A; similarly value 101 or 200 should also return A, and if its out of range it just prompts the value is out of range. or we would use the tradition if-else loops

can it be done with vlookup??? pl guide me out.

Thanks,

[PeterB]

Your question is confusing, but is the solution in the attached file what you want?

[corinereyes]

Hi,

Try the attached file.

Formula used is =
INDEX(A:C,MATCH(F1,B:B),1)