vlookup excel

  TheTerminator 16:11 29 Jan 2003

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

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

  cherria 17:55 29 Jan 2003

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 2003


  TheTerminator 16:54 30 Jan 2003

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 2003

What you have written


should work.

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

  VoG™ 20:38 30 Jan 2003

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 2003

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 2003

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.

Elsewhere on IDG sites

iMac Pro review

25 book design and illustration tips

iMac Pro review

Idées cadeaux pour geeks et tech addicts