I have a few reports I have to compare with hundreds of entries. I have taken the important information and put it all in one spreadsheet to make this easier. A list with only a few numbers is in column A. A quantity associated with each number in A is also in column B, and column C contains a much larger list, with numbers that are and aren't in column A. I need to check if the number in C also exists in A, look up the quantity in B in the same row as the number in A, then return into column D. Anything can be returned if there isn't a value, only the entries with return values are important. I used N/A in my example.
EX:
A B C D (These are the results I want)
2 8 1 N/A
5 3 2 8
6 2 3 N/A
4 N/A
5 3
6 2
I have this formula from another stackoverflow question at Excel formula to look up and pick a value
=VLOOKUP(C1, A$1:B$4, 2)
From how the question and answer are worded, it should produce the results I need once I extend the range to contain all 118 entries in A and B (B$118 I think), but every result I get is an N/A, 1, or 3, almost all of which are incorrect. The only difference I can see is my C is longer than my A, where their C is shorter than their A. I am not familiar with excel's functions and syntax, and would appreciate help.