1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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

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]

Want to read more?

Check out the full article on the original site

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