formula

E

ericlch16

Active Member
Joined
Nov 2, 2007
Messages
313
Office Version
  1. 2016
  2. 2013
Platform
  1. Windows
I have a column E:

aaa
bbb
ccc

I have column F

bbb
ccc
ddd

I want column G to have a formula so that
found in E
found in E
not found in E

what is the formula i can write in column G:
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
Hello,

Assume the data starts at row 2.

G2, copy down.

=IF(COUNTIF(E:E,F2),"Found in E","Not Found in E")
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Split cell based on another cell's value
Replies
3
Views
180
Scott Huish
Scott Huish
A
  • Question Question
Auto populate columns in one tab based on entries in another
Replies
6
Views
122
dermie_72
D
A
  • Question Question
Parsing text with different number of dashes
Replies
6
Views
374
alansidman
A
ExcelNewbie2020
  • Question Question
Vlookup function to look for similar value but the different return value
Replies
6
Views
337
ExcelNewbie2020
ExcelNewbie2020
J
  • Question Question
how to replace some values
Replies
2
Views
296
jamiguel77
J

Forum statistics

Threads
1,224,590
Messages
6,179,749
Members
452,940
Latest member
rootytrip

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top