T
Tenfjord
Hi!
Im using the following formular In an Excel Spreadsheet to get
information from a Pivott table.
"INDEX(Sertifikat!A:AT;MATCH(B5;Sertifikat!A:A;0);25)"
The name entered In cell B5 match up a name In the area
"Sertifikat!A:A" and return a date from column 25. from the actual
person.
When the column Is empty It return a default date, "0.1.00"
My question Is. Can It be possible to get information from the next
column. 26 when column 25 Is empty. Do need to use IF settings ?
Im greatfull for any answer !
Im using the following formular In an Excel Spreadsheet to get
information from a Pivott table.
"INDEX(Sertifikat!A:AT;MATCH(B5;Sertifikat!A:A;0);25)"
The name entered In cell B5 match up a name In the area
"Sertifikat!A:A" and return a date from column 25. from the actual
person.
When the column Is empty It return a default date, "0.1.00"
My question Is. Can It be possible to get information from the next
column. 26 when column 25 Is empty. Do need to use IF settings ?
Im greatfull for any answer !