Trying to present a cut down table using VLookups

[whirlwind147]

Hi,


Not really sure the best way to describe what I need to do but I'll give it a go.


I have a stock listing for one of our customers of all we hold for them and they want to see a cut down version of this on a different sheet in the same workbook but only items that meet certain criteria. I've sorted out the formula I need to highlight just these items on the original sheet but I'm having trouble listing the different items on a separate sheet. I've used a VLookup but (as most of you will know being experts) it's picking up the same entry again and again as the identifier on the main sheet is the same.

I've currently got this formula on a few rows:
=VLOOKUP("BI!",'ProdSchedRep'!$A$1:$X$100,2)
And it's picking up the same row each time from the other sheet. What would I need to do to this to get it to show each row with the same identifier? I'm guessing that VLookup isn't the right formula to try but I don't know what is. I've tried to search the forums but not knowing the right formula I do need to use I'm finding it a struggle to search!

If more info is needed then let me know what you need and I'll supply
Thanks for any help you can give.

 

[Special-K99]

I don't want to waste time replicating data you have already set up so can you post a link to the spreadsheet as you can post attachments on this forum.

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

Attachments

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[whirlwind147]

Haven't I done that? The message right after me saying I was having issues?