Extract listed data from data sheet.

Excel sheet contains some data. What formula should i use to extract selected, listed data from contains data sheet?

sampledataworkorders.xlsx

You can use

Formula:

Please Login or Register  to view this content.

But this will not work in a structured table.

Originally Posted by Fluff13

You can use

Formula:

Please Login or Register  to view this content.

But this will not work in a structured table.

I used your formula the function isn't valid. I also removed structured table simply copy and paste as value but still isn't valid error message.
Attachment 759028

You're attachment is coming back as invalid. But if you are getting an invalid function message it suggest that you are not using xl2021. So what version of Excel are you using?

Originally Posted by popipipo

Please Login or Register  to view this content.

Try this one (maybe change ; into ,)

Yes these actually worked its simple and effective, thanks for your contribution.

Fluff13 I am using xl2021. I dont know why my attachment is coming invalid to you. I will attach again here .Attachment 759029 https://www.excelforum.com/attachmen...1&d=1639239935

HTML Code: 

To attach an image you need to go to "Go Advanced" & then attach the image, otherwise it doesn't work.
Did you download the workbook I supplied? If so did that work?

what u have given to me the formula is coming like these {=_xlfn._xlws.FILTER(WorkOrders2,ISNUMBER(MATCH(WorkOrders2[WO],R24:R43,0)))}. Its worked on sheet what u supplied to me but when i use other formula in other cell or other sheet i got error #NAME? .

HTML Code: 

If you open the workbook that I supplied, & you get this {=_xlfn._xlws.FILTER(WorkOrders2,ISNUMBER(MATCH(WorkOrders2[WO],R24:R43,0)))} then you do not have the filter function.