Microsoft Excel - Looking up multiple values/multiple sheets (same workbook)

I have 1 excel workbook, 3 sheets.
I have 3 criteria that I need to match on:
Worksheet 1: contains client name
Worksheet 2: contains client name, code and SKU, and close date
Worksheet 3: contains clisent name, code and SKU, and forecast close date

I need Worksheet 1 to look in Worksheets 2-3, match the client name with each  exact code and SKU (they MUST be the same exact match in both Worksheet 2 and Worksheet 3), and return both the close date and forecast close date to worksheet 1.

Any ideas?

Thanks!

Hi Tammy,
Not immediately obvious what you want.  Perhaps a workbook with some indicative data and resultant output would help or post some tables with data from each sheet in the blog (less desirable).
Regards
Harry

Here is Sheet 1:
A1:          B1:               C1:

Client Name

Actual Close Date

Forecast Close Date

Here is Sheet 2:
A1:          B1:           C1:      D1:

Client Name	Actual Close	SKU	CODE
ABC Company	11/02/2026	123	ABC
		456	DEF
XYZ Company	09/03/2026	789	BYR
123 Company	09/04/2026	567	YRH

Here is Sheet 3:
A1:            B1:          C1:      D1:

Client Name	Forecast Close	SKU	CODE
ABC Company	12/01/2026	123	ABC
		456	DEF
XYZ Company	09/15/2013	789	BYR
123 Company	11/01/2026	567	YRH

**So what I need is for Sheet 1 to look in Sheet 2 and 3, find a match for Client Name, SKU and CODE (must appear in both Sheet 2 and 3), and return the values to Sheet 1.

For example, If ABC Company, SKU 123 and CODE ABC exists in Sheet 2, then look in Sheet 3 and find the match (all 3 must match, company name, SKU and CODE) If a match is found, then return the "Actual Close" value from Sheet 2 into Sheet 1. Also, if a match is found, then return the "Forecast Close" value from Sheet 3 into Sheet 1. Client name must also be returned to Sheet 1.

Thanks!~!!!!!!!

Hi Tammy,
Do the cell positions in sheets 2 and 3 always match (eg if ABC Co in cell A2 on Sheet2 it is in A2 on Sheet3 etc)?  I also assume that there can be varying numbers of SKU and Code for each client?
If you don't mind me asking, is there a particular reason that you have the data in this format? It doesn't strike me as being particularly efficient.  Perhaps you would be better to review your data input/collection.
Regards
Harry