Multiple lookup function formula

[Sayeed]

Good afternoon,

I am trying to write a formula which looks at information in Hanshin Worksheet, specifically cells A2 and also at Q1, R1, S1 etc, and based on that criteria, looks up the information in Price List Data and retrieves pricing from there.

So for e.g. A2 = HS0000700R001 and therefore returns pricing for D of $189, for R $189, for S $189 etc.

Any help will be much appreciated.

Thanks

http://www.excelforum.com/editpost.p...postid=3970412

[FDibbins]

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.