Posted to microsoft.public.excel.worksheet.functions

PR[_2_]

external usenet poster

Posts: 27

How to look up 2 Cell Values

I wish to lookup 2 cells and if they = a certain value then set number in
another cell...
eg:

if
b2 = a4 and d2 = 1 then cell x2 = 10
b3 = a4 and d3 = 4 then cell x3 = 8
b4 = a3 and d4 = 4 then cell x4 = 8

and so on...

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
VLookup multiple values - sum returned values into single cell	se7098	Excel Worksheet Functions	12	April 2nd 23 07:32 PM
Copy values from a cell based on values of another cell	Spence10169	Excel Discussion (Misc queries)	4	January 13th 09 10:01 AM
How to assign values to a cell based on values in another cell?	Joao Lopes	Excel Worksheet Functions	1	December 5th 07 09:02 PM
Replacing Linked Cell Values w/ Current Values	TomCat	Excel Worksheet Functions	6	April 10th 06 12:20 PM

All times are GMT +1. The time now is 03:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us