| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select a cell based on an other cell's value
Hi! I've got an excel-table. It looks something like this. Table1 (A1)Month (B1)SMS January 106 February 220 Mars 50 (A6)Max: =MAX(B2;B4) (A7)Min: =MIN(B2;B4) Now I want to find out what month B6 and B7 is and placing them in C6 & C7. In SQL I would have done something like SELECT `month` FROM table1 WHERE SMS = B6 How do I do this?! Many thanks, wally_91 -- wally_91 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting a cell with colour based on whether another cell's valu | Excel Worksheet Functions | |||
| Applying conditional formatting to cell based on another cell's in | Excel Discussion (Misc queries) | |||
| How do I populate a cell with another cell's value based on condit | Excel Worksheet Functions | |||
| Creating a conditional format for a cell based on another cell's v | Excel Discussion (Misc queries) | |||
| Conditional Formating for a cell based on another cell's value | Excel Discussion (Misc queries) | |||
Threaded Mode
