vlookup excel

  TheTerminator 16:11 29 Jan 03
Locked

Quick qn please:

I currently have the formula "=VLOOKUP(VALUE,A28:B31,2,TRUE)"
where VALUE is a different amount relating to the table. Is it possible to make the VALUE a cell reference, so it will read as
"=VLOOKUP(B2,A28:B31,2,TRUE)"

Obviously I have tried this but have had no joy. Can you help?
Thanks.

  cherria 17:55 29 Jan 03

Yes, there is no problem with that.

Bare in mind that using TRUE at the end means that if vlookup does not find a match it will return the nearest smaller value. If you want only to return a value if there is an exact match, then make th elast paramater a FALSE

  cherria 11:59 30 Jan 03

Sorted?

  TheTerminator 16:54 30 Jan 03

sorry. i havent had much opportunity to be online over the past few days...
Can you spell out what I would need to type in please?
I have again experimented but am ultimately unsure of what to enter. Hope that this does not seem a stoopid question,

  VoG™ 19:52 30 Jan 03

What you have written

=VLOOKUP(B2,A28:B31,2,TRUE)

should work.

What happens when you use this formula? Have you tried changing the TRUE to FALSE?

  VoG™ 20:38 30 Jan 03

If you can post the values in A28:B31 and the VALUE you want in B2 I can try it out for you. Don't try formatting the numbers to look like a spreadsheet - it won't work. Just post something like:

A28:A31 1, 2, 3, 4

B28:B31 7, 8, 9, 10

  TheTerminator 21:06 30 Jan 03

Hope you area still online...

A28 B28
0 0
83.46 10
112.32 22
621.92 40

Values in column A are rates of pay, so B28 is values 0.01 pounds - 83.46 and a31 is £621.92 and more money.
Column B is the rate of tax you charge a person.
I want the comp to take a value in say B2 and for it to work out the rate of tax i need to pay...
Hope this is clear..
If you want to email me any workings out could you please send it to
JontyLeese AT Hotmail dot com

Good man!

  VoG™ 21:29 30 Jan 03

Your formula works perfectly for me. I've e-mailed an example to you.

If this doesn't do what you want, please post back.

This thread is now locked and can not be replied to.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch