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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…