VLOOKUP query


2 Answer(s)


You can use the VLookup function in the same manner where the table array is in another worksheet, you just need to go to that worksheet and select the range of data.

NOTE: Make sure you make the table array as absolute by pressing F4 key.

vlookup use to lookup a value you want to find in an excel list or table using vlookup is similar to looking up a persons name in a telephone book to get a telephone numbers it looks a value in one column