Look Up & Referencing

[KPV_0921]

Hello all,

Need help with an Excel formula. I am working on my team's data right now and in the sheet I have 2 tabs 1) Raw Data 2) Exception. How can I automate a column in the Raw Data to automatically have Yes for an item that is in the other tab Exception? Thanks in advance!

 

[myall_blues]

Are you just comparing one column to one other column? Can you post some example data?

 

[KPV_0921]

So in the attached image, I need to look up Column A if it is listed in the exception list from the Exception tab. If it is, Column T in the Raw tab should be Yes

 

[Peter_SSs]

For the future I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be. Also easy to copy from to test with.
If you have trouble with XL2BB review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of theXL2BB Instructions page linked above.

See if adapting this to your ranges does what you want.

KPV_0921.xlsm
	A
1	Item
2	Item 1
3	Item 3
4	Item 9
5	Item 4
6	Item 10
7	Item 6
8
Exception

KPV_0921.xlsm
	A	B
1	Item	In Exception?
2	Item 2
3	Item 4	Yes
4	Item 1	Yes
5	Item 5
6	Item 3	Yes
Raw Data

Cell Formulas
Range	Formula
B2:B6	B2	=IF(COUNTIF(Exception!A2:A10,A2:A6),"Yes","")
Dynamic array formulas.

 

[KPV_0921]

For the future I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be. Also easy to copy from to test with.
If you have trouble with XL2BB review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of theXL2BB Instructions page linked above.

See if adapting this to your ranges does what you want.

KPV_0921.xlsm
	A
1	Item
2	Item 1
3	Item 3
4	Item 9
5	Item 4
6	Item 10
7	Item 6
8
Exception

KPV_0921.xlsm
	A	B
1	Item	In Exception?
2	Item 2
3	Item 4	Yes
4	Item 1	Yes
5	Item 5
6	Item 3	Yes
Raw Data

Cell Formulas
Range	Formula
B2:B6	B2	=IF(COUNTIF(Exception!A2:A10,A2:A6),"Yes","")
Dynamic array formulas.

I tried downloading but I can't seem to successfully install it. When I extract the downloaded file, it is just an empty folder.

 

[Peter_SSs]

Where did you download the zip file to?
Where did you extract it to?