i need help in understanding on which lookup function can i use, that fetches values from another sheet in serial order. In the attached image you would see that a product has multiple order id's. I want the lookup to fetch values in serial number(ignoring the value fetched earlier) when product name is entered twice in the lookup sheet. Is there a vba function or a formula for such search. I am a novice and help will be appriciated.
Original Sheet
Lookup sheet
No comments:
Post a Comment