Excel......?Using Vlookup for a range 1

[WingandaPrayer]

Afternoon,
How do I have a calculation in one cell which will show something else in another cell.

Currently using Vlookup if I enter F1D in cell D1 option 7 will show in E1. Option 7 is in a list of codes and options elsewhere in the worksheet.F2D would give me Option 8.

My problem occurs if I use vlookup when I have a range to look up instead of one static answer.

e.g. cell A1 * B1 gives 0.500 in C1……
I would like D1 to show F , if C1 is below 1.00
If C1 has 0.67 I would like D1 to show F
If C1 has 1.02 I would like D1 to show G…….etc,etc
I have 5 ranges …below 1.00
>=1.00 < 2.00
>=2.00 < 2.50
>= 2.50 < 3.00
>= 3.50

I hope I have explained clearly enough for someone to give me an idea.

Thanks in advance.

David

 

[JVFriederick]

I'm a little bit confused by your question, but I'll try and help as best I can. Enter the following in cells E1:F6

0.67 A
1.00 B
2.00 C
2.50 D
3.00 E
9999 F

In cell D1, enter the following equation :
=VLOOKUP(C1,E1:F6,2,TRUE)

Using the TRUE parameter in VLOOKUP allows a match in-between &quot;exact&quot; matches. Normally FALSE is used in case the order is not sorted.

You may need to add more values for the low end . . . I couldn't tell what they were.

 

[WingandaPrayer]

Thank you for searching through a jungle of a question.

Just what I required. I just had to add $ for all other rows

It worked with =VLOOKUP(C1,$E$1:$F$6,2,TRUE)

Thanks again for spending the time to read my mess.

David

 

[JVFriederick]

Glad it helped. ;-)