Combining vlookup and hlookup (urgent) :'(

Hey Guys, This is my first post so dont be hard to me, i just got an assignment my boss told me to use VLOOKUP and HLOOKUP to combine her formula so it'll make it easier for her to set her price on her product..

SampleTxT.xlsx

As you can see on that file, she want me to make it simple for her to know the price of (For example : if she put operative pack with 450 employee she can get the price 30000 and 15 user and 80 ESS) and

she wanted it if the employee 500 << that data will automatically goes to 30000 Price (Operative) if the employee 501 >>> that data will automatically goes to 40000 Price, 30 User, 160ESS

And the other way around PAyroll pack employee 5001 The Price will be 60000, name user will be Unlimited, ESS wil be unlimited...







SOrry for my english X_x..

sumthing like this???

=IF(B22<=500,B24&B30&B31,IF(C22>500,C24&C30&C31,IF(D22>1000,D24&D30&D31,IF(E22="unlimited",E24&E30&E31))))

Originally Posted by k64

Having the ranges in the same cell stores them as text instead of numbers and makes them hard to work with. I've added another row to fix this. After that, you could use HLOOKUP and VLOOKUP, but I have a personal preferences for INDEX and MATCH so that's what I used.

First of all thanks to you, for your time to solve this man, you made my day...
I Guess i should learn more about Excel, you really are awesome man..

Originally Posted by jayajaya_4

sumthing like this???

=IF(B22<=500,B24&B30&B31,IF(C22>500,C24&C30&C31,IF(D22>1000,D24&D30&D31,IF(E22="unlimited",E24&E30&E31))))

I'm sorry man, i'm noob in excel, so i dont really get it where to put those formula, but thanks again i appreciate your effort for helping me solving this prob

but unfortunately mine was not the right approach and thanks for appreciating it...

k64 had helped u well