Re: Vlookup bringing no number

If you think that there is a match and excel is screwing up, check out Debra
Dalgleish's site to help trouble shoot your formula (and data!).

http://contextures.com/xlFunctions02.html#Trouble

Joe wrote:

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

--

Dave Peterson
.