If formula finding text in a formula driven cell

I have this formula giving me what i want in the cell =INDEX(Table4[Part Number],MATCH("ReOrder",Table4[Re-Order],0))

But i want to put it in a =if(Table4[Re-Order] = "ReOrder", INDEX(Table4[Part Number],MATCH("ReOrder",Table4[Re-Order],0)),"")

It just comes up blank it doesnt seem to be able to check that the Re-Order in table4 contains the text ReOrder

Re-Order in table 4 is a formula based cell to show blank or re-order.

Thanks for any help provided

You are trying to apply a condition based on a row from another table. How does Excel know which row to check in Table4[Re-Order]?

I want to check all rows and o ly return ones with reorder in them. Are you sayong that the formula cant do this best to do with vba ?

At the moment Table 4 only has one record in it.

I think you need more data than one row and mock-up in your results table what you should see based on the sample.

The formula you have won't work as it is.

That is ok i did it with vba Thanks for your help