using a location reference, combine information from two tabs into a consolidated list

I have a listing of locations with various management levels indicated in several columns. I also have a listing various test points with location number. The location number is the common link. How can I take combine the information by location number into one schedule which will show the data and the management information, I have attached a shortened sample. The real report has several hundred locations.

Thanks in advance

Something like this for the columns in Data:

=IFERROR(INDEX(Data!$A:$I,MATCH('Combined Data'!$A2,Data!$A:$A,0),MATCH('Combined Data'!B$1,Data!$2:$2,0)),"")

And this for the columns in FGE Store List:

=IFERROR(INDEX('FGE Store List'!$A:$I,MATCH('Combined Data'!$A2,'FGE Store List'!$H:$H,0),MATCH('Combined Data'!J$1,'FGE Store List'!$1:$1,0)),"")

See attached. Note I deleted the "Location" column in the right hand set (Q), and removed the two leading 0s in column H of FGE Store List to get them to match. You will need to ensure the location numbers actually match, or if there are always some leading zeroes then this can be dealt with by adding "+0" in the relevant places to force everything to be treated as a number for lookup purposes.

Brilliant... This will really help... and I had no chance of figuring it out on my own... Thank you

thanks for the quick response... unfortunately, I only use the Mac (and often regret it.