I have two columns in Excel, let’s call them A and B. I want to see if the numerical IDs in column A are also captured in column B or not. What formula would help me get this?

like
Posting as :
works at
You are currently posting as works at

Isnumber(match() would also work

likesmartuplifting

Vlookup

like

Thanks! I was able to figure it out with the IF(ISERROR) formula

So, 2 columns of independent data & you want to see if those in A are also in B?

In column C, perhaps =iferror(vlookup(A1,B:B,1,0),”Not Captured”). Then filer column C for the desired output.

You could also use conditional formatting to highlight duplicates. Then filter by color to find the doubles.

Might work, can’t say without more info.

like

If helpful I can also DM a screenshot if my description doesn’t make sense

Xlookup

Countif($B$1:$B$1000,A1)

Easiest

Related Posts

I have a question in general about boot camps with ISAs.

Does anyone know if they monitor how hard or how often you actually job search after you complete the program? What if you just don’t try to get a job so that you don’t have to pay them back?

like

Apologies if I missed it but...

Post Photo
likefunny

I have offers from Amex and GS with similar Fixed component but the joining date of GS is two months after my last day in the current organization whereas Amex joining date is immediate. Should I wait for GS date or go ahead with Amex?

like

Can you guys recommend any course or training to get PHR certify?

like

Thoughts on being asked to do a test project post interview? Sr AD with a portfolio to back it up. Responded saying I could do it at my freelance rate, they replied back saying since it's not a "real project" they wouldn't pay for it.

like

This is an embarrasing question to ask, but at what number do you feel like your net worth is a sign that you're "successful"? I'm honestly trying to evaluate for a sense of where I place within the market/if I've been making intelligent decisions.

like

What’s the best way to network with bankers? Is cold emailing okay or does it annoy people? Thanks for any advice.

like

How long it takes to get the technical interview result?

like

Can we take resignation back in ADP after serving NP for 45 days ?

I had a patient, a white woman, who felt that she had to explain to me, a black woma, how racist she wasn't by pointing out her biracial kids. Rubbed me the wrong way.

like

What was WFH scenario in EY GDS before covid?
My joining is in March, is it mandatory to join office , I am working from outside GDS location.

like

Thinking of getting a 1Bd in old town / Lincoln park. Curious what others here are paying for a 1bd 1 bath in the area?

like

Looking for a matte red lipstick that is a great shade, long-wearing, doesn't dry out, and doesn't stick on teeth. Does anyone have a favorite they can recommend?

like

Hi fishes,
Currently I am invested in two mutual funds:
UTI nifty index
Parag parikh flexi

Which other MFs are worth investing?

like

WWYD: No offer details a month after a verbal offer.

like

Hello Fishes, need help and suggestions on best online platform for doing courses on Sailpoint or Saviynt, where we can understand with the help of practical scenarios. Thanks.

My peers are not getting as much work as me. I pride myself on being a hard worker and a team player, but it’s getting out of hand. I have been working 80+ billable hours the past month+

likefunny

Genpact whats the pay bracket for band 4C in pharma analytics team?

100 members. Let's keep this bowl alive 😀

like

Additional Posts in Excel Genius

Are there any great market sizing and business case spreadsheet templates that you guys have come across? I came across this SaaS valuation template in this bowl which was super helpful, but nothing for sizing or business casing. Appreciate any help.

likehelpful

Is there an absolute moron’s guide to Index Match? I have two tables of users, some exist on table A that don’t on B, and vice versa. I need to merge them based on their email as the unique identifier

like

Hoping someone can help me write a formula for the blue cells. Trying to return the unique ID from my data using 2 lookup criteria where the first is the Name in column A and the second is the date in column B that falls between the appropriate date range for that Name in my data. All names are spelled/formatted exact same in lookup table and data table so no issues with respect to extra spaces, periods, etc. Picture attached for reference. Any help is greatly appreciated.

Post Photo
like

Does anyone here use ASAP Utilites as an Excel add-in? This thing is amazing.

like

I'm stumped!
Coworker creates "Sheet A" with invoice numbers
I use Monarch to extract invoice #'s and amounts from another report.
I do a pivot table to compile amounts by invoice. I copy those results to "Sheet Z".
I then do an @vlookup on Sheet A referencing Sheet Z (just the invoice # and amount).
It isn't working unless I go to Sheet Z and type over the invoice # (same number)! All invoice #'s are absolute and in the same font & alignment. Workbook has 10 yrs data. Has worked in past!

like

What are the most useful macros you’ve seen that could be used across multiple projects?

like

Help this is probably dumb. I have a workbook with 30 tabs. Is there a quick way to separate each in to its own book or should I copy one a time?

like

I have a large binary file (20mb) . When trying to reference another workbook in formula, excel won’t recognize the other workbook. Any fixes? I’ve been trying to reduce size

like

I have a large spreadsheet with lots of dates, how can I identify classification based on the dates below? I.e. if your hire date was in between these parameters, it flags you. nested IFAND?

Post Photo
like

Does anyone know how to keep in leading zeros when converting to a number, so I can do a vlookup across data sets?

like

Does anyone have any recommendations for a really good excel training course? I’m based in LA and would prefer an in person course but if there is a highly recommended online program, I’m open to that too. I’m looking for more detailed pivot table instruction and more advanced classes in formulas and macros macros

like

I did this manually but would there be a way to pivot the dates (day/month) in the rows years in columns with raw data being (date/month/year) needed a visual of same day different year

Post Photo

Maybe I’m late to the party but I just discovered the ASAP Utilities excel add-in and my life is changed. These tools can save loads of time!

like

Just wanna say thank you to this group of beautiful people, always willing to help each other reach a solution!

likeuplifting

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

like

How TF do I attach the SharePoint version of a slide deck in an email? Every time I try to share, it gives me the link in the email body instead of an actual attachment to open in app. PLEASE AND THANK YOU

like

Hello again fishies...

Column D in tab 1 and tab 2 is a drop down list which has 6 items.

In tab 3 how can I return the Cells in Column a b and c (tab 1 and 2) when the value in cell d(tab 1 and 2) is one of the 6 items selected

like

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Help, simple task can’t figure it or. List of user names in one sheet compare to another list on another sheet and highlight duplicates.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal