Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can anyone show me the fomula under the condition of below ?
Column A1 got a list. List data = A,B,C Column B1 will get info from another colum according what A1 appear. Column E1=ABC Column E2=BCD Column E3=CDE If, A1=A B1 will get answer from E1 if, A1=B B1 will get answer from E2 if, A1=C B1 will get answer from E3 Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |