vlookup

[Pauls123]

Hi, How can I write a simple vlookup formula where in the follow:

=VLOOKUP(AX2,$AZ$2:$BA$10,2,FALSE)

each cell in column AZ is a range of numbers, eg 0-50 and then 50-100 etc.

Then column BA has just one number in it, eg 5
and Column AX has say a number 25 in it

so therefore I want my result to return a 5

Excel 2010, thanks, Paul

 

[Aladin Akyurek]

Are you saying that AZ2 houses literally 0-50?

 

[Pauls123]

yes,.....a range of numbers

 

[Aladin Akyurek]

yes,.....a range of numbers

You could change that set up to:

0
50
100
150

instead of

0-50
50-100
100-150
150-200

so that you can invoke:

=VLOOKUP(AX2,$AZ$2:$BA$10,2,1)

 

[Pauls123]

but does this give me numbers in the middle like say,...10,..15,...25, etc, things like that. In my range

Paul

 

[Aladin Akyurek]

but does this give me numbers in the middle like say,...10,..15,...25, etc, things like that. In my range

Paul

Did you try it?

 

[Pauls123]

yes, but its just not working out the way I want it,,...I must be doing something wrong.

 

[Pauls123]

Thanks Aladin, I'll have to keep thinking about this one

 

[Aladin Akyurek]

Thanks Aladin, I'll have to keep thinking about this one

You are welcome. If you need more help, try to post a portion of the table data here.