Vlookup bringing no number

[Joe]

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

 

[Fred Smith]

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

Regards,
Fred.

 

[JLatham]

What do you mean "doesn't bring two values?

If you mean that there are two values in the look up list that match the
contents of D3155, then that is normal; VLOOKUP() always stops looking at the
first match it finds.

Explain more about "doesn't bring two values". Also, does it bring back
anything from other columns (when changing ,7, to some lesser value)?

 

[JLatham]

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]

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

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?

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

 

[Joe]

Sorry Fred, what I meant to say. This is not working for two values in my
search. eg it brings correctly a number for all of them, but the last two
numbers on my list, doesnt bring anything. However, if I search that in the
second spreadsheet I find two numbers. But Vlookup doesnt bring these two
numbers. Any other idea?
Thanks,
jose

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

Regards,
Fred.

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

 

[Dave Peterson]

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

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