there is no spaces, I ve copied and pasted the number on the second
spreadsheet to make sure of that and also run a search by the same number and
it brings up only one line. Exactly as expected as it was alreayd sorted. Any
other ideas why it migh not be picking up this number

"JLatham" wrote:

I should have added that if it's not returning anything (or maybe a #N/A),
check and make sure the values in $A in that lookup table are exactly the
same as in D3155. A value you think should be matching up in the lookup
table may have an added space or two somewhere that you aren't noticing -
most likely at the right end of a text entry. Or your value in D3155 has the
added spaces?

"Joe" wrote:

HI. My friend is having some problems with Vlookup. I checked the formula and
it is correct. It goes to another spreadsheet 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