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.
[link] [comments]
Want to read more?
Check out the full article on the original site