if this cell is equal to this cell on another sheet then enter the value of the adjacent cell.

[daren141]

if this cell is equal to this cell on another sheet then enter the value of the adjacent cell. It works somewhat but its reporting numbers for the wrong cell. i have sheet one and sheet 2 imported below. any help would be appreciated.

Sales Report V2.xlsx
	A	B	C	D	E	F	G
3	OrderNo	RequiredDate	QuoteDate	ShipTO_Name	Custom1	Custom2	Custom3
4	17940	1/3/2022	1/3/2022	Signature Bank			No
5	17941	1/3/2022	1/3/2022	Signature Bank			No
6	17942	1/3/2022	1/3/2022	Signature Bank			No
7	17943	1/3/2022	1/3/2022	Vonage			No
8	17944	1/3/2022	1/3/2022	Vonage			No
9	17945	1/3/2022	1/3/2022	Kyowa Kirin			No
10	17946	1/3/2022	1/3/2022	Newark Board of Education			BESSEMER
11	17947	1/3/2022	1/3/2022	Bold			No
12	17948	1/3/2022	1/3/2022	Transverse Insurance			HIG, EY
13	17949	1/3/2022	1/3/2022	Provident Bank			No
14	17958	1/3/2022	1/3/2022	Amalgamated Life			DEUTSCHE
expC625

Cell Formulas
Range	Formula
G4:G14	G4	=INDEX(source!$E$3:$E$1346,MATCH(source!D3,expC625!$A$4:$A$1927,0))

Sales Report V2.xlsx
	B	C	D	E
3	17940	Signature Bank	17940	No
4	17941	Signature Bank	17941	No
5	17942	Signature Bank	17942	No
6	17945	Kyowa Kirin	17945	No
7	17949	Provident Bank	17949	No
8	17963	Provident Bank	17963	No
9	17965	Christopher Lang	17965	No
10	17965	Christopher Lang	17966	No
11	17966	Christopher Lang	17982	No
12	17982	Worldwide Logistics	17984	No
13	17982	Worldwide Logistics	17985	No
14	17982	Chronograph	17986	No
15	17982	New Jersey Innovation Institute	17988	No
16	17984	New Jersey Innovation Institute	17991	BESSEMER
17	17985	New Jersey Innovation Institute	17992	No
18	17986	New Jersey Innovation Institute	17996	No
19	17986	New Jersey Innovation Institute	17997	No
20	17988	New Jersey Innovation Institute	17998	No
21	17991	New Jersey Innovation Institute	17999	No
22	17992	New Jersey Innovation Institute	18000	No
23	17996	New Jersey Innovation Institute	18002	No
24	17997	New Jersey Innovation Institute	18003	No
25	17998	The Children's Aid Society	18006	No
26	17999	Michael Greer	18008	No
27	18000	National Utility Service, Inc.	18009	No
28	18002	National Utility Service, Inc.	18010	No
29	18003	National Utility Service, Inc.	18011	No
30	18003	National Utility Service, Inc.	18012	No
31	18003	National Utility Service, Inc.	18013	HIG, EY
32	18006	Baruch S. Blumberg Institute	18014	No
33	18006	Baruch S. Blumberg Institute	18015	No
34	18006	Baruch S. Blumberg Institute	18017	DEUTSCHE
source

Cell Formulas
Range	Formula
D3:D1346	D3	=UNIQUE(B3:B1725)
E3:E34	E3	=TEXTJOIN(", ",TRUE,UNIQUE(FILTER($A$3:$A$1725,(expC625!A4=$B$3:$B$1725)*($A$3:$A$1725<>"WHS")*($A$3:$A$1725<>"P1"),"No")))
Dynamic array formulas.

 

[awoohaw]

im not sure if it just how you did the xl2bb or if it is your worksheet. but your lookup column has only 32 values to return, even though you are listing 1346 cells in the index array..

 

[daren141]

im not sure if it just how you did the xl2bb or if it is your worksheet. but your lookup column has only 32 values to return, even though you are listing 1346 cells in the index array..

theres a lot of data and theres a limit on how muh i could actually use with xl2bb i kept getting error messages so i just selected enough to get an idea of what im trying to accomplish

 

[awoohaw]

Understood. But, I'm having a hard time with your initial statement unless i have a better picture of what you're trying to accomplish:
"if this cell is equal to this cell on another sheet then enter the value of the adjacent cell. It works somewhat but its reporting numbers for the wrong cell. i have sheet one and sheet 2 imported below. any help would be appreciated."

what is the address of "this cell"? what is the address of "this cell on another sheet" (Is it hard coded or are you using a lookup of some kind)? Is the other sheet cell adjacent up, down, right, left (or is this an expected return value from the lookup)?

What are the values of the "this cell", "The other sheet cell", and the "adjacent" cell when you have an error/wrong return? Do you have duplicate values in the "other sheet cell" column (if it is a column)?