View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SIGE SIGE is offline
external usenet poster
 
Posts: 206
Default Writing formulas ...

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