Hello !

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.

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 "0.1.00"

Do i need to use "If" function ?

Does' anyone have a clue ?

Thanks for answer ! :)


--
Tenfjord
------------------------------------------------------------------------
Tenfjord's Profile: http://www.excelforum.com/member.php...o&userid=32425
View this thread: http://www.excelforum.com/showthread...hreadid=522121