PDA

View Full Version : Solved: Mulit Point Lookup Formula



Blade Hunter
03-01-2011, 10:30 PM
Hi Guys, I have a small issue, I need to look up
some information, I could do it with code but I would love to do it with
formulas if possible.

Here is my sample data:

Edit: Grrrr, the board doesn't take HTML sample data. Anyone know how to post a table from Excel in to here?

Here are the rules:
I have the config (Example DA2)
I have a price (Example 15.28)
I need to find the Tier and the Class.
Some prices appear in multiple spots. In this case I need to follow these
rules:
Stay Standard if possible
Otherwise check one column to the left and right of standard
If still not found check one more column out and so on and so forth.
In my example I would expect Standard and Tier 1 to be returned

As another example I have DA1 and 4.11 as the price
I would expect Mid Tier 5 to be returned over Budget 4 or Super Budget 3
Hope that makes sense and hope this can be done with formulas, don't worry
about posting VBA code as I can do that myself and I don't want to waste anyones time but if it can be done with formulas I would be super happy.

I can reconfigure the layout or repeat the config headings if needed,
this data will be used for this purpose only so I can play around with the
layout (initially it came from elsewhere which is the reason for the format)

Cheers

Dan

shrivallabha
03-01-2011, 10:59 PM
Maybe you can post a sample in Excel itself?

mancubus
03-02-2011, 03:26 AM
Anyone know how to post a table from Excel in to here?


when posting, scrool down, manage attachments, upload.

Blade Hunter
03-02-2011, 03:35 PM
It's all good, resolved on another board :)

http://www.mrexcel.com/forum/showthread.php?t=532821

Thanks anyway.

Dan