excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version Standard

Bhavini has attended:
Excel Intermediate course

Excel

how do you do v-look-ups? and what is that?

RE: excel

Its used to see if data from one data set exists in another data set. Handy if you have two sets of data with the same type of fields (for example two sets of client names and adress) and you want to see if any from one set exist in the other set.

If you have two sets of data, highlight the second set and in the top left corner of the screen is the name box, in this box type 'Range1' and press the Enter key. Create a new column in your first set of data. In the first cell use the following formula:

=VLOOKUP(B1,Range1,1,FALSE)

This is essentially saying "take the value in B1 (B is the ID column of your first data set), and see if it occurs anywhere in Range1 (Range1 is the ID column of your second data set). If it does appear then it will return the ID (column 1, hence the 1 in the formula) and if it doesn't appear then it will return '#N/A'. The value of 1 will make it return the ID value. You can return any column in the range. For example, if you have column1 as the ID and column2 as the full name then you can change the formula as follows to return the second colum and therefore show the name:

=VLOOKUP(B1,Range1,2,FALSE)

Please see attached example

Attached files...

Example.xls


Server loaded in 0.09 secs.