by
Ansab Khan , AVP / Unit Head - Digital HR Solutions , Meezan Bank Ltd
For Example,
you enter employee no and want to appear Name in next column. thats fine apply vlookup and done. but the problem is, when you don't enter employee and you have to put formula because you have to deliver to client, vlookup would give an error #n/a
i have confronted this, my client shouted that what you have done to my file, this is full of error.
then i apply vlookup with if.
=if(a1="","",vlookup())
this is one use there could more.
there are a lot of ways to use VLOOKUP. here are some of the ways i use it:
* with a dynamic range, use a named range
=VLOOKUP(lookup value,NAMED RANGE,column,false)
* if you do not know which column, use MATCH or COLUMN function
=VLOOKUP(lookupvalue,table array,MATCH(lookup value,lookup array,0),false)
* or even a VLOOKUP inside a VLOOKUPs:
=VLOOKUP(VLOOKUP(lookup,table array,column,false),table array,column,false)
and the long list goes on, just try to be practical and don't overdo it. there are a lot of variations but to put them all here is not possible.
by
jasmine ramirez , Executive Assistant to the CEO , Al Barakah Investment and Holding Company LLC
VLOOKUP Formula - is a unique formula when you want to get your report or consolidated it, its makes your life easy.Specially when you are working in Macro.
The advantage of using VLOOKUP formula is it would be easier for you to search, find, copy for the information or data from the other sheets/table. it will automatically input and find the information that your looking for. Unlike doing it manually you still have to search for the words from the other sheet and copy and paste it one by one.
if we have a table of products or employee or customer we can use in diferant place like another sheet we can use only id to get other information in the row wit our formula vlookup
