Simplify a function to save speed?

Hello.

I have this function :
{=INDEX(NAME;MATCH($B$3&$D$3;PART.NO&SUP.NO;0))}

I use it on 40 different places in one sheet and I change NAME to the Detail I want to search for in the table.
It works really slow and I thought that if I could find the row where part number and Supplier number is like what I search for than I could maybe speed things up by writing a more simple function in the 40 cells.

Lets say that the function I am searching for returns ROW=2.
Than I would be able to look for NAME in ROW 2 only instead of searching through each cell.

How can I determain the row number?

/Anders

Hi,

Well, it the match portion of your formula which searches and finds the row number ...

A macro would speed up the whole process ..

HTH
Carim

thank you very much. It speeded it up very much

/Anders