Hi, I'm trying to use Vlookup & Match combination to grab text content in cells but it's not working well and I would like someone to help. I have List A, List B and List C. I'm trying to see if an item in list A occurs in List B. If it does, I want Vlookup to grab applicable item from List C and show it in another cell. Match will give me the location of the item in List B, but it does not return the content of the cell. Vlookup & Match combination will give me content of a wrong cell. I have example below:
List A List B List C
18AP NAN-A aa-21C
182ES 18AP za-11C
43TH3 042SP ey-31C
1. Comparing A list to B: Match for "18AP" is "2" for 2nd row. The code I need in List C is za-11C and it's correct. But my spreadsheet is 5K long and I don't want to count.
2. Vlookup will return "aa-21" but it's not the correct code.
How do I tell formula to get the correct code? Am I using a wrong combination? Any guidance is appreciated!
Bookmarks