hey guys,

I am really new at the visual basic and my problem is, that my excel file works with vlookup, but it is really complex so that it slows down the sheet.

For example what I try to do.
I have 3 work sheets.
On the first sheet is in column D a lot of numbers, which are most in the other sheets.
Now the macro should find the number from the first worksheet in the other sheets and should give out two other column, which are next to the number. if the number is not in the other sheets then it should be blank.
Here how it work with vlookup

=IF(ISNA(VLOOKUP(D8,INDIRECT("'"&INDEX({"Auto","Sitz"},MATCH(1,--(COUNTIF(INDIRECT("'"&{"Auto","Sitz"}&"'!B2:M1000"),D8)>0),0))&"'!B2:M1000"),9,0)),"",VLOOKUP(D8,INDIRECT("'"&INDEX({"Auto","Sitz"},MATCH(1,--(COUNTIF(INDIRECT("'"&{"Auto","Sitz"}&"'!B2:M1000"),D8)>0),0))&"'!B2:M1000"),9,0))

Hopefully someone can help me.
Thanks for your efforts.

Best regards,
Buno