G
Guest
Hi everyone,
I was given a formula from this group regarding VLOOKUP, extreemly helpfull
and many thanks, but I do not like to use formulas I do not understand. Can
anyone please explain to me how it works. The first part of the formula I
understand it is the second part I do not understand:
=VLOOKUP(A1,B1:C300,2,FALSE). What do the number 2 and False represent in
the formula?
I use it to find transactions related to names, but if I have transactions
relating to the same name it always goes for the first transaction: Example:
B1= John - C1= 100
B2= Peter - C2= 200
B3= John - C3= 300
If I want the result in E1, when I get the name John it will always give me
the first result, is there a possibilty to get both transactions?
Thank you
Albert
I was given a formula from this group regarding VLOOKUP, extreemly helpfull
and many thanks, but I do not like to use formulas I do not understand. Can
anyone please explain to me how it works. The first part of the formula I
understand it is the second part I do not understand:
=VLOOKUP(A1,B1:C300,2,FALSE). What do the number 2 and False represent in
the formula?
I use it to find transactions related to names, but if I have transactions
relating to the same name it always goes for the first transaction: Example:
B1= John - C1= 100
B2= Peter - C2= 200
B3= John - C3= 300
If I want the result in E1, when I get the name John it will always give me
the first result, is there a possibilty to get both transactions?
Thank you
Albert