Hi ,
I would like to seek help on multiple rows and columns look up using Index and match.
I am attaching a file caled "indexqueryfile" with two sheets:
a. Rawdata
b. report format - The report looks up the data from the raw data sheet
I would like to seek help on :
a. What is wrong with the formula in the file in report tab as it is not returnign unique values
b. What should be the best formula to use under such circumstances eg multiple rows and columns look up
Many Thanks
Bookmarks