About Us

hurairah

Dear Collagues,

Really needs your helps.

My situation is I have three cell. The first cell is Product and the second cell is Hardness. My problem is I don't know how to put automatically value in third cell based on the comparison of first and second cell. As example, if the Product is MD700 and Hardness is 30, then the value in the third cell is 3.7. If Product is MD700 and Hardness is 40 then the value in the third cell is 3.9. Could anyone please help me? Please take 13 products and 3 hardness as your reference.

Really need your help and with my kindest regards,
Hurairah

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linking Groups of cells between workbooks	vnacj-joe	Excel Discussion (Misc queries)	4	June 14th 07 05:18 PM
Help with this conditional IF statement	C-Dawg	Excel Discussion (Misc queries)	3	May 15th 06 06:01 PM
Return a cell value based on specific combinations of cells in an array	rmcnam05	Excel Worksheet Functions	2	October 11th 05 03:28 AM
Compare data - one cell to multiple cells	srs710	Excel Discussion (Misc queries)	1	July 20th 05 11:43 AM
Help adding text values	Texas-DC_271	Excel Worksheet Functions	7	January 15th 05 11:14 PM

Menu

About Us