software

Hello !

Im using the following formular In an Excel Spreadsheet to get
information from a Pivott table.

quot;INDEX(Sertifikat!A:AT;MATCH(B5;Sertifikat!A:A ;0); 25)quot;

The name entered In cell B5 match up a name In the area
quot;Sertifikat!A:Aquot; and return a date from column 25. from the actual
person.

My question is, can it be possible to search in the next column in easy
way If 25 is empty. The next column would be 26.

When cell in Column 25 Is empty It return the defalt date quot;0.1.00quot;

Do i need to use quot;Ifquot; function ?

Does' anyone have a clue ?

Thanks for answer ! --
Tenfjord
------------------------------------------------------------------------
Tenfjord's Profile: www.excelforum.com/member.php...oamp;userid=32425
View this thread: www.excelforum.com/showthread...hreadid=522121