Changing a IF(VLOOKUP) into VLOOKUP

Hi all,

I am currently using this formula:

=IF(VLOOKUP(E$9,Tabelle2!$A$2:$AP$5500,ROW($A2),TRUE)="","",VLOOKUP(E$9,Tabelle2!$A$2:$AP$5500,ROW($A2),TRUE))

Can this be changed to a VLOOKUP formula and keep the same results.

As always, You help is greatly appreciated

regards

Jeremy