Posted to microsoft.public.excel.misc

tomhelle

external usenet poster

Posts: 24

Lookup Price based on two values

Have a data table on sheet 2 as follows:

Material 1 Thickness 1 Price 1
Material 1 Thickness 2 Price 2
Material 2 Thickness 1 Price 3

On sheet 1, I will specify the desired Material and Thickness but need a
formula to lookup the associated price.

Example: If I specify Material 1 and Thickness 2, I want a result of Price 2.

Many thanks in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup price formula	jimE	Excel Worksheet Functions	2	October 23rd 07 12:49 AM
Price Lookup	Joe Black	Excel Worksheet Functions	13	March 31st 07 05:37 AM
Lookup Based on 4 values	[email protected]	Excel Discussion (Misc queries)	3	December 22nd 06 07:57 PM
Populating a field based on lookup values	Sav_C	Excel Worksheet Functions	5	August 6th 06 02:49 AM
Vlookup based on two lookup values	Trip	Excel Worksheet Functions	2	April 8th 05 06:25 PM

All times are GMT +1. The time now is 03:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us