On many occasions it is necessary to combine information from the program that is in different listings into a single one with all the information we want.
In the video shown below, it is explained how to perform a vertical search in excel. As mentioned in the video, depending on the version of excel you are working with, the formula to be used will be different although with the same results:
=VLOOKUP
=HLOOKUP
VIDEO: How to perform a vertical search
Important note: in order to perform the vertical search, the common data to the two listings of the table in which you are going to search must be in column A.
Comments
0 comments
Please sign in to leave a comment.