|
|
|
|||||||
| Off Topic This section may contain threads that are NSFW. This section is given a bit of leeway on some of the rules and so you may see some mild language and even some risqué images. Please no threads about race, religion, politics, or sexual orientation. Please no self promotion, sign up, or fundraising threads. |
 |
|
|
Thread Tools | Display Modes |
03-09-2021, 01:54 PM
|
#1 |
|
Member
|
Excel Vlookup(I think) question
I have two columns of data. One row has many more cells of data. I want to see if what is in one column is in the next column.
So I have column A and B. A has 1000 Cells of data B has 1500. I need to see if what is in A1 is in any of the 1500 cells in row b. I need to do this for all 1000 lines of data in Column A Thanks
__________________
Comment of the day “How many bees are killed by mowing?”- Boo |
|
|
|
03-09-2021, 02:12 PM
|
#2 |
|
Member
Join Date: Sep 2012
Posts: 7,990
|
Couldn't a simple conditional formatting for duplicate content work?
__________________
Every day I start to ooze. |
|
|
|
|
03-09-2021, 02:23 PM
|
#3 |
|
Member
|
|
|
|
|
|
03-09-2021, 02:39 PM
|
#4 |
|
Member
|
=vlookup(B1,A,1,false)
|
|
|
|
|
03-09-2021, 03:33 PM
|
#5 | |
|
Member
|
Quote:
Thanks I was overthinking it
__________________
Comment of the day “How many bees are killed by mowing?”- Boo |
|
|
|
|
|
03-09-2021, 09:43 PM
|
#6 |
|
Member
Join Date: Nov 2012
Location: Yes
Posts: 2,089
|
Just a heads up, XLookup is alot better to use than Vlookup.
__________________
Collecting 2012, 2013 Topps Chrome Colored refractors as well as any rare Kris Medlen, Brandon Beachy cards |
|
|
|
|
| Bookmarks |
|
|
Linear Mode
