Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Computer Help and Support

MANative

(4,144 posts)

3. Yeah, I found something in my searches that supports your thought

Reply to underpants (Reply #1)

Wed Feb 7, 2024, 11:34 AM

Feb 2024

... converting the two spreadsheets into tables and putting the tables in tabs on that same spreadsheet. Then use the tables as the basis for VLOOKUP. Exploring that further.

Edit history

Please sign in to view edit histories.

Recommendations

0 members have recommended this reply (displayed in chronological order):

12 replies

= new reply since forum marked as read

Highlight:

Any Excel gurus in the house? [View all] MANative Feb 2024 OP

Would it help to have them together on the same spreadsheet? underpants Feb 2024 #1

Yeah, I found something in my searches that supports your thought MANative Feb 2024 #3

Merge all the data then clip out what BootinUp Feb 2024 #2

That was my first attempt MANative Feb 2024 #4

I would use ms access then BootinUp Feb 2024 #5

Sadly, my company doesn't provide us access to that software, because I think you're probably right. NT MANative Feb 2024 #6

Excel can do something similar BootinUp Feb 2024 #7

Yeah - I think that's the way I'm going to handle it. Tables seem necessary to making this work. Thanks!! NT MANative Feb 2024 #8

One more thought. BootinUp Feb 2024 #9

That sounds viable, too. I will probably need this data for additional scrapes... MANative Feb 2024 #10

Can you give me a better idea of what the data is, and how it's arranged? lastlib Feb 2024 #11

Thanks for the offer!! MANative Feb 2024 #12