Excel 2007 : Complicated HLOOKUP or VLOOKUP based on many values

[luigihikari]

Hello everyone,

I have a very complicated workbook I'm working on.

I attached an example workbook:
example.xlsx

Basically, here is the deal.

The user can select 3 inputs: A, B or C.

Based on that, Excel has to look through an extensive list based on those three values and return two columns of different values.

So, concatenating: A \ A \ A
Color: Blue
Size: 40
Price: $40,00

And for: A \ A \ B
Color: Red
Size: 50
Price: $50,00

Possibly, with the "color, size, price" in a different column.

Can anyone please help me or point me in the right direction?
The example workbook attached can really help picture the case.

Thank you very much for your attention!

[SCLai]

Please refer to attached.

Hope this is what you are looking for!

SC

[FDibbins]

a vlookup will give you what you need. but a few comments on your sample workbook...

1. if your live workbook is set up in the same way, i would recommend you change the layout. i reformatted your data on the data sheet to make the lookups more efficient.

2. avoid merge and center if you can, use format/center across, it also makes lookups easier

3. to combine your data for the search, you can just do it the way i did in my vlookup formula...unless you really want to add the /, you dont need it

anyway, take a look at what i have and let me know if this is something you can work with?

[luigihikari]

Hello SCLai, FDibbins,

Thank you very, very much!

This helped me immensely! Actually, it practically solved the problem for me.
Thanks a lot!

Also, I'll follow your guidelines, FDibbins!

I repped both of you for the help, though it's not much compared to the help you provided.

Thank you!

[FDibbins]

glad to help