Forum Discussion

Richard Bonilla's avatar
Richard Bonilla
Copper Contributor
Sep 18, 2018

Advance filters Question

What I want to do is type in a FG code (In Sheet 2, Cell A5,) and find all components appear in sheet two. I need these so that I can see all the associated parts to the item (comp part #). Also, would it be possible to simply write the Vlookup in cell A5 (the FG code), then have the advance filter automatically fill the comp part$ information for that FG code? 

Resources