| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to return the value of a cell based on two criterias in two columns
hi, friends i need help on this one,, please help me.. i have a list in col A which has been categorised as H/W or S/W in co B col A col B laptop h/w HDD h/w cdrw hw Ms Office s/w Adobe s/w what needs to be done: in col C if i put "laptop" then col D should show "h/w" and if i put "Adobe" or "Ms Office" then col D should show "s/w" how do i do it..please hel -- devdutt_de ----------------------------------------------------------------------- devdutt_dev's Profile: http://www.excelforum.com/member.php...fo&userid=1218 View this thread: http://www.excelforum.com/showthread.php?threadid=26533 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a value based on 2 or more columns of information | Excel Worksheet Functions | |||
| sum based on 4 criterias | Excel Discussion (Misc queries) | |||
| Return value in 3rd column based on 2 other columns | Excel Discussion (Misc queries) | |||
| Lookup based on 2 columns; return 1 value | Excel Worksheet Functions | |||
| Insert values based on 2 criterias | Excel Discussion (Misc queries) | |||
Threaded Mode
