Hi I need some help please
In G2 on the STD tab I need it to look up the MPN on the product and match the STD MPN and then I need to identify the STD MPN that match the Product MPN that are less than £1.00 in value.
Hope this makes sense and iv attached the document I'm working on.
Last edited by AliGW; 04-01-2020 at 10:55 AM.
Sorry, not following. So, in G on STD, lookup the MPN (from Col A)... that's as far as I could follow.
Do you want to look on "Working" to match that MPN (guessing since I don't see it on the PRODUCT tab) and then return what?
You say you want to return the Product MPN that is less than £1.00? or are you returning something else. The Product Import tab doesn't contain either MPN or prices. The "Working" tab only contains a single instance of any particular MPN. Will there be multiple results or just a single result under £1.00?
What exactly are you expecting to see in STD col G; prices? Product description, SKU???
Other that that, it's perfectly clear.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks