lkpbetter.blogg.se

This formula will check if the contents of Cell A2 (Thom Yorke) exist in the List of Artists 2. All we need to do is to enter the following formula into cell B2 Now, we are going to use the trusty VLOOKUP formula. I’m going to create a column to the right of each list (right-click on column B and select ‘Insert’) and label it ‘does Artist exist in other lists?’ At first, let’s prepare the space on the sheet.

Well, the task is to see if artists in List 1 are in List 2 AND vice versa. I’ve got a List of Artists 1 and a List of Artists 2 (spot your favorites!) So, with that said, let’s go forth and use the trusty VLOOKUP to get this done. It’s not a lengthy guide on the subject, anyhow George will answer your queries! It’s not some complex report or analysis we are building, it is just verification and that’s the premise of this quick guide.

Simply, we just want to confirm if data exists for investigative reasons. Now, unless you are prepared to spend some time using VBA to do complex scripting, you won’t get a precise result. We want to see if one ‘bunch’ of data exists within another bunch of data. Compare Two Columns In Excel Using VLOOKUP