Thread: Return cell value if column criteria are met.

Hi, I am attempting to create a client-specific worksheet based on a general worksheet.

I have a workbook which manages hypothetical advertising data for a certain website (websiteX.com). Within this workbook I have five worksheets, each dedicated to a different page on websiteX.com (pageA, pageB, pageC, pageD, and pageE). Within each of these worksheets I have four tables. The first table is a summary of the advertisements (impressions) for each of three possible advertisement spaces (i.g. Leaderboard, Skyscraper, and MPU). The following three tables is a client-breakdown of the advertising on each of the advertisement spaces. So I have one table which lists all the clients who have impressions in the Leaderboard space, one table which lists all the clients who have impressions in the Skyscraper space, and one table for all the clients who have impressions in the MPU space. For each client within each of these tables I have important information in columns such as Impressions Sold, Impressions Served, etc.

I would like to create a separate table for each of the clients which would summarize all of their impressions. In this summary table I would like to breakdown how many impressions a client was sold, served, etc. in each adspace on each page. For example, for client A I would like a table which told me how many impressions sold they had in pageA Leaderboard, pageA Skyscraper, pageA MPU, pageB Leaderboard, pageB Skycraper, pageB MPU, etc.

For this client-specific table I have set up the first column to identify all possible adspaces (e.g. pageA Leaderboard, pageA Skyscraper, pageA MPU, pageB Leaderboard, pageB Skycraper, pageB MPU, etc). Now I need a formula which can return the value in the important columns (e.g. impressions sold) for each of the first column's criteria.

For example: In the first column of the table I want to make for clientA, I have "pageA Leaderboard." In the second column I would like to return the cell containing the Impressions Sold from the "Impressions Sold" column in the Leaderboard Table for pageA which pertains to clientA.

I'm sorry for the long introduction, but I have seen so many of these posts cause confusion because not enough background info was provided.
Thanks for any help.