We can copy both the list in same or to be more clear in
different sheets.
On an available cell, we need to write the VLOOKUP function
as below, So this lookups for a value in
an array range and if
found returns a column of that matched row.
Range lookup = true – approx. match will be returned
Range lookup = false – exact match will be returned
range_lookup (optional)
|
A logical value that specifies whether you want VLOOKUP to
find an exact match or an approximate match:
·
TRUE assumes the first column in
the table is sorted either numerically or alphabetically, and will then
search for the closest value. This is the default method if you don't specify
one.
·
FALSE searches for the exact value
in the first column.
|
So below function fulfils our purpose.
