V lookup

%3CLINGO-SUB%20id%3D%22lingo-sub-1821432%22%20slang%3D%22en-US%22%3EV%20lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1821432%22%20slang%3D%22en-US%22%3EHi.%3CBR%20%2F%3EI%20am%20needing%20help%20with%20a%20formula%20I%20need%20to%20pull%20across%20the%20cost%20string%20from%20sheet%20one%20into%20sheet%202.%20But%20only%20have%20the%20purchase%20order%20to%20use%20as%20reference.%20But%20some%20orders%20may%20have%20multiple%20cost%20strings%20linked%20to%20them.%20Is%20there%20a%20way%20that%20if%20the%20occurs%20to%20bring%20all%20cost%20strings%20accross%20or%20even%20get%20an%20error%20message%20to%20come%20up%20if%20the%20order%20has%20more%20then%20one%20cost%20string.%20When%20I%20do%20it%20with%20Vlookup%20it%20brings%20accross%20the%20cost%20string%20it%20first%20comes%20across.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1821432%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1821768%22%20slang%3D%22en-US%22%3ERe%3A%20V%20lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1821768%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F479853%22%20target%3D%22_blank%22%3E%40Eddy162%3C%2FA%3E%26nbsp%3BIf%20you%20are%20on%20an%20Excel%20version%20that%20supports%20the%20new%20FILTER%20function%2C%20the%20attached%20file%20perhaps%20%26nbsp%3B%20contains%20the%20solution%20you%20want.%20I've%20also%20added%20an%20alternative%20that%20gives%20the%20cost%20string%20and%20a%20notification%20if%20there%20are%20more%20than%20one%20for%20a%20PO.%3C%2FP%3E%3CP%3ENote%2C%20I've%20used%20a%20few%20named%20ranges%20to%20keep%20the%20formulae%20easier%20to%20read%20and%20maintain.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1822277%22%20slang%3D%22en-US%22%3ERe%3A%20V%20lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1822277%22%20slang%3D%22en-US%22%3EThank%20you%20very%20much!%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor
Hi.
I am needing help with a formula I need to pull across the cost string from sheet one into sheet 2. But only have the purchase order to use as reference. But some orders may have multiple cost strings linked to them. Is there a way that if the occurs to bring all cost strings accross or even get an error message to come up if the order has more then one cost string. When I do it with Vlookup it brings accross the cost string it first comes across.

Thank you.
2 Replies
Highlighted

@Eddy162 If you are on an Excel version that supports the new FILTER function, the attached file perhaps   contains the solution you want. I've also added an alternative that gives the cost string and a notification if there are more than one for a PO.

Note, I've used a few named ranges to keep the formulae easier to read and maintain.

Highlighted
Thank you very much!