Find "A" then "B" and return "B" (or "Found")

Our take

Are you looking to streamline your spreadsheet tasks by efficiently cross-referencing data between two tabs? You’re not alone. Many users face challenges when trying to match codes and amounts across different sheets. In this scenario, you have a primary tab with unique codes and corresponding amounts, and a secondary tab where those codes appear multiple times with various amounts. The goal is to find a specific amount from the first tab and verify its existence in the second tab.

Hey folks, I feel like I'm missing something obvious for something so simple.

Let's say tab 1 has codes and numbers. Tab 2 has the same codes but many more numbers for each code. I simply want to look up a code and then find the specific number provided on tab 1 to see if it exists on tab 2. I then would like either the number returned or any verbiage confirming it was found.

Nothing I have found on YouTube is working for me.

Additional explanation if needed: Tab 1- Column A has letter codes, each represented once. Column B has amounts. Tab 2- Column A has the same letter codes listed multiple times. Column B has amounts. (So there could be 5 amounts with the same code in column A) I need to search for Tab 1 columns A and B (on Tab 2) simply to know that Tab 1 B exists on Tab 2 B.

Screenshots of example spreadsheet in the comments.

submitted by /u/PrncssBttrcpAsUWish
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#no-code spreadsheet solutions#rows.com#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#Excel compatibility#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#financial modeling with spreadsheets#automation in spreadsheet workflows#AI-powered spreadsheet#Excel alternatives#spreadsheet API integration#codes#tab 1