Vlookup
Hi Carina,
Am Mon, 12 Aug 2013 11:10:06 +0100 schrieb carina21:
Quantity Name date account
0.150 xxx 31.07.2013 120
0.140 xxx 31.07.2013 130
0.120 xxx 31.07.2013 140
120 yyy 31.05.2013 10
2 yyy 31.05.2013 18
...
you have to look for the whole name. And the search column in VLOOKUP
has to be the most left column of the matrix.
Try:
=VLOOKUP("xxx",B:C,2,0)
or
=VLOOKUP(B2,B:C,2,0)
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|