Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi There,
Is it possible to do the following? 1. In column B from row 6 downwards: (***up to last row in column C*** (no empty rows)) WRITE THE FORMULA: (for B6:) =IF(ISERROR(VLOOKUP(C6;ACCOUNTS;1;FALSE));B5;VLOOK UP (C6;ACCOUNTS;1;FALSE)) ("increasing" for B7 as copying down the relative formula manually) 2. In column A from row 6 donwards: WRITE THE FORMULA: (for A6:) =IF(IF(ISERROR(VLOOKUP(C6;ACCOUNTS;1;FALSE));B5;VL OOKUP(C6;ACCOUNTS;1;FALSE))=C6;"";IF(ISERROR(VLOOK UP(C6;ACCOUNTS;1;FALSE));B5;VLOOKUP(C6;ACCOUNTS;1; FALSE))&C6) Small step for guru? ... too big step for me! So, Any help really appreciated! :o) Sige |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
writing formulas | New Users to Excel | |||
Writing formulas between sheet | Excel Discussion (Misc queries) | |||
writing if formulas | Excel Worksheet Functions | |||
Writing Formulas | Excel Worksheet Functions | |||
Problem writing formulas - please, please help! | Excel Programming |