I need help to get the result as above using Formula in Excel
I need help to get the result as above using Formula in Excel
Look up the VLOOKUP function in Excel help. It will help you find any data from a row which has an identifier. For example, if you know the number "2017-63" you can find the description "Mango". Normally, all of that wouldn't be on the same tab, however, at least not in the same table.
I think if you use Excel Help you will probably find all the guidance you need. You might also google for VLOOKUP and find examples. But if you need more help than that post a copy of your workbook and we shall design a formula for you that you can use right away.