| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pick up particular number from a table
sorry, D1 and E1 should be 05/10
-- Lowan "Lowan Chan" wrote: Hi, I have below table: A B C D E 1 04/10 04/10 04/10 04/10 2 AB YZ AB YZ 3 MARY 45 56 16 62 4 PETER 50 48 84 45 5 JOHN 60 78 65 50 How can i get number 45 at B3 when I have reference 04/10, AB, and Mary in another sheet? thanks a lot! -- Lowan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pick the 5th number out of the following number 1002300. | Excel Worksheet Functions | |||
| How to pick a value out of a table | Excel Worksheet Functions | |||
| FORMULA TO PICK NUMBER | Excel Worksheet Functions | |||
| I need to total col, but pick up number in other col. if not 0 | Excel Worksheet Functions | |||
| how to pick from a range of table values | Excel Worksheet Functions | |||
Linear Mode
