مطالب مرتبط با «excel check register» در back soft | نویسنده: استخدام کار
Excel - Check if a number in column C is in A and return the value in B - have a code, but can't get the results
Vote count: 0 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 retu into column D. Anything can be retued if there isn't a value, only the entries with retu 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 ...
ادامه مطلب
