Suppose that the numbers are numbered from 1 to a certain column in Excel sheet A.
Suppose that some numbers are sequentially shaken in a column of Excel sheet B.
How can I take only the number of sheet B out of sheet A?
How to use VLOOKUP
and filters
Column A on sheet A is numbered from 1 to 1 (the first line is entered as the item name from the second line)
Column A on sheet B has several numbers in order
=VLOOKUP(A2, Sheet B! Absolute range of numbers (e.g., $A$1:$A$10), 1,FALSE)
in column B of Sheet A
Fill in (copy as many columns A, double-click on the bottom right)
#N/A
if it is not in the specified range of sheet B, so
Set #N/A
without equalization in the filter.
© 2024 OneMinuteCode. All rights reserved.