Re: Vlookup bringing no number

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Actually, there is a reason for that. Vlookup will always return only one value.

Regards,
Fred.

"Joe" <Joe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9B9AE50A-0A6A-4FF3-BCD7-DB6986A56969@xxxxxxxxxxxxxxxx
HI. My friend is having some problems with Vlookup. I checked the formula and
it is correct. It goes to another spread*** and needs to bring a value.
The Formula is working well but it doesnt bring two values. Apparantely,
there is no reason for that.
He has already sort his file [std Costs 2007-2008.xls]std Costs July Revised'
=VLOOKUP(D3155,'[std Costs 2007-2008.xls]std Costs July Revised'!$A:$G,7,0)

Thanks

.


Quantcast