Hi, I have got a data in sheet1 from which it the data needs to be fetched into a table in Sheet2 depending on the vendor name, Month and Performance (headers in row 2 of the sheet1). Is it possible to get this done by formulas? I tried a combination of vlookup, Index and Match with no luck.
can any one please help me on this? Thanks in advance!!
Bookmarks