Thread: Need similar formulas to do the job

VLOOKUP is not a subsitute for using SUMIF. Myabe what you mean is you want
to lookup A10 in that range. If so, try

=VLOOKUP($a10,Mo!$A$1:$D$999,4,false)


"sonar" wrote:

>
> Hi
>
> I am currently using the following formula
> =SUMIF(Mo!$A$1:$A$999,$A10,Mo!$D$1:$D$999)
>
> the problem is, I dont want to use the SUMIF, I want to use the
> VLOOKUP, but the VLOOKUP does not want to work so nicely. My other
> formulas are easily "rattled" should I try and touch the formatting of
> the sheets cells.
>
> Is there any other functions I can use that will give me what I want?
>
> Regards
> Sonar
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>
>

What makes you think that you want VLOOKUP, it is nothing like SUMIF.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sonar" <sonar.1up4ug_1125605155.6674@excelforum-nospam.com> wrote in
message news:sonar.1up4ug_1125605155.6674@excelforum-nospam.com...
>
> Hi
>
> I am currently using the following formula
> =SUMIF(Mo!$A$1:$A$999,$A10,Mo!$D$1:$D$999)
>
> the problem is, I dont want to use the SUMIF, I want to use the
> VLOOKUP, but the VLOOKUP does not want to work so nicely. My other
> formulas are easily "rattled" should I try and touch the formatting of
> the sheets cells.
>
> Is there any other functions I can use that will give me what I want?
>
> Regards
> Sonar
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile:
http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>

You can use 'trim' or 'value' to force the key value to the needed type to
work inside the vlookup. Ex: =vlookup(value(a10),Mo!$a:$d,4,false) if the
values in column A on the Mo worksheet are numeric but cell a10 contains
text. =vlookup(trim(a10),Mo!$a:$d,4,false) should work in the opposite case.

As others noted, this all requires that your values in column A on the Mo
worksheet are unique. Otherwise vlookup would NOT be a suitable replacement
for sumif.


"sonar" wrote:

>
> my 13 digit numbers only works in cells formated as Text, unfortunatly,
> if I try to have them any other way, the other formula that puts in the
> description, does not work.
>
> Vlookup does not want to match up text formulated info with General
> formulated info.
>
> I know that Sumif calc. information, but it works where vlookup does
> not. The problem is, I dont want it to calculate.
>
> Any idea what I can use here?
>
> Regards
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>
>

VLOOKUP is not a subsitute for using SUMIF. Myabe what you mean is you want
to lookup A10 in that range. If so, try

=VLOOKUP($a10,Mo!$A$1:$D$999,4,false)


"sonar" wrote:

>
> Hi
>
> I am currently using the following formula
> =SUMIF(Mo!$A$1:$A$999,$A10,Mo!$D$1:$D$999)
>
> the problem is, I dont want to use the SUMIF, I want to use the
> VLOOKUP, but the VLOOKUP does not want to work so nicely. My other
> formulas are easily "rattled" should I try and touch the formatting of
> the sheets cells.
>
> Is there any other functions I can use that will give me what I want?
>
> Regards
> Sonar
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>
>

What makes you think that you want VLOOKUP, it is nothing like SUMIF.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sonar" <sonar.1up4ug_1125605155.6674@excelforum-nospam.com> wrote in
message news:sonar.1up4ug_1125605155.6674@excelforum-nospam.com...
>
> Hi
>
> I am currently using the following formula
> =SUMIF(Mo!$A$1:$A$999,$A10,Mo!$D$1:$D$999)
>
> the problem is, I dont want to use the SUMIF, I want to use the
> VLOOKUP, but the VLOOKUP does not want to work so nicely. My other
> formulas are easily "rattled" should I try and touch the formatting of
> the sheets cells.
>
> Is there any other functions I can use that will give me what I want?
>
> Regards
> Sonar
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile:
http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>

You can use 'trim' or 'value' to force the key value to the needed type to
work inside the vlookup. Ex: =vlookup(value(a10),Mo!$a:$d,4,false) if the
values in column A on the Mo worksheet are numeric but cell a10 contains
text. =vlookup(trim(a10),Mo!$a:$d,4,false) should work in the opposite case.

As others noted, this all requires that your values in column A on the Mo
worksheet are unique. Otherwise vlookup would NOT be a suitable replacement
for sumif.


"sonar" wrote:

>
> my 13 digit numbers only works in cells formated as Text, unfortunatly,
> if I try to have them any other way, the other formula that puts in the
> description, does not work.
>
> Vlookup does not want to match up text formulated info with General
> formulated info.
>
> I know that Sumif calc. information, but it works where vlookup does
> not. The problem is, I dont want it to calculate.
>
> Any idea what I can use here?
>
> Regards
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>
>

VLOOKUP is not a subsitute for using SUMIF. Myabe what you mean is you want
to lookup A10 in that range. If so, try

=VLOOKUP($a10,Mo!$A$1:$D$999,4,false)


"sonar" wrote:

>
> Hi
>
> I am currently using the following formula
> =SUMIF(Mo!$A$1:$A$999,$A10,Mo!$D$1:$D$999)
>
> the problem is, I dont want to use the SUMIF, I want to use the
> VLOOKUP, but the VLOOKUP does not want to work so nicely. My other
> formulas are easily "rattled" should I try and touch the formatting of
> the sheets cells.
>
> Is there any other functions I can use that will give me what I want?
>
> Regards
> Sonar
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>
>

What makes you think that you want VLOOKUP, it is nothing like SUMIF.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sonar" <sonar.1up4ug_1125605155.6674@excelforum-nospam.com> wrote in
message news:sonar.1up4ug_1125605155.6674@excelforum-nospam.com...
>
> Hi
>
> I am currently using the following formula
> =SUMIF(Mo!$A$1:$A$999,$A10,Mo!$D$1:$D$999)
>
> the problem is, I dont want to use the SUMIF, I want to use the
> VLOOKUP, but the VLOOKUP does not want to work so nicely. My other
> formulas are easily "rattled" should I try and touch the formatting of
> the sheets cells.
>
> Is there any other functions I can use that will give me what I want?
>
> Regards
> Sonar
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile:
http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>

You can use 'trim' or 'value' to force the key value to the needed type to
work inside the vlookup. Ex: =vlookup(value(a10),Mo!$a:$d,4,false) if the
values in column A on the Mo worksheet are numeric but cell a10 contains
text. =vlookup(trim(a10),Mo!$a:$d,4,false) should work in the opposite case.

As others noted, this all requires that your values in column A on the Mo
worksheet are unique. Otherwise vlookup would NOT be a suitable replacement
for sumif.


"sonar" wrote:

>
> my 13 digit numbers only works in cells formated as Text, unfortunatly,
> if I try to have them any other way, the other formula that puts in the
> description, does not work.
>
> Vlookup does not want to match up text formulated info with General
> formulated info.
>
> I know that Sumif calc. information, but it works where vlookup does
> not. The problem is, I dont want it to calculate.
>
> Any idea what I can use here?
>
> Regards
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>
>

VLOOKUP is not a subsitute for using SUMIF. Myabe what you mean is you want
to lookup A10 in that range. If so, try

=VLOOKUP($a10,Mo!$A$1:$D$999,4,false)


"sonar" wrote:

>
> Hi
>
> I am currently using the following formula
> =SUMIF(Mo!$A$1:$A$999,$A10,Mo!$D$1:$D$999)
>
> the problem is, I dont want to use the SUMIF, I want to use the
> VLOOKUP, but the VLOOKUP does not want to work so nicely. My other
> formulas are easily "rattled" should I try and touch the formatting of
> the sheets cells.
>
> Is there any other functions I can use that will give me what I want?
>
> Regards
> Sonar
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>
>

What makes you think that you want VLOOKUP, it is nothing like SUMIF.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sonar" <sonar.1up4ug_1125605155.6674@excelforum-nospam.com> wrote in
message news:sonar.1up4ug_1125605155.6674@excelforum-nospam.com...
>
> Hi
>
> I am currently using the following formula
> =SUMIF(Mo!$A$1:$A$999,$A10,Mo!$D$1:$D$999)
>
> the problem is, I dont want to use the SUMIF, I want to use the
> VLOOKUP, but the VLOOKUP does not want to work so nicely. My other
> formulas are easily "rattled" should I try and touch the formatting of
> the sheets cells.
>
> Is there any other functions I can use that will give me what I want?
>
> Regards
> Sonar
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile:
http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>

You can use 'trim' or 'value' to force the key value to the needed type to
work inside the vlookup. Ex: =vlookup(value(a10),Mo!$a:$d,4,false) if the
values in column A on the Mo worksheet are numeric but cell a10 contains
text. =vlookup(trim(a10),Mo!$a:$d,4,false) should work in the opposite case.

As others noted, this all requires that your values in column A on the Mo
worksheet are unique. Otherwise vlookup would NOT be a suitable replacement
for sumif.


"sonar" wrote:

>
> my 13 digit numbers only works in cells formated as Text, unfortunatly,
> if I try to have them any other way, the other formula that puts in the
> description, does not work.
>
> Vlookup does not want to match up text formulated info with General
> formulated info.
>
> I know that Sumif calc. information, but it works where vlookup does
> not. The problem is, I dont want it to calculate.
>
> Any idea what I can use here?
>
> Regards
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>
>

VLOOKUP is not a subsitute for using SUMIF. Myabe what you mean is you want
to lookup A10 in that range. If so, try

=VLOOKUP($a10,Mo!$A$1:$D$999,4,false)


"sonar" wrote:

>
> Hi
>
> I am currently using the following formula
> =SUMIF(Mo!$A$1:$A$999,$A10,Mo!$D$1:$D$999)
>
> the problem is, I dont want to use the SUMIF, I want to use the
> VLOOKUP, but the VLOOKUP does not want to work so nicely. My other
> formulas are easily "rattled" should I try and touch the formatting of
> the sheets cells.
>
> Is there any other functions I can use that will give me what I want?
>
> Regards
> Sonar
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>
>

What makes you think that you want VLOOKUP, it is nothing like SUMIF.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sonar" <sonar.1up4ug_1125605155.6674@excelforum-nospam.com> wrote in
message news:sonar.1up4ug_1125605155.6674@excelforum-nospam.com...
>
> Hi
>
> I am currently using the following formula
> =SUMIF(Mo!$A$1:$A$999,$A10,Mo!$D$1:$D$999)
>
> the problem is, I dont want to use the SUMIF, I want to use the
> VLOOKUP, but the VLOOKUP does not want to work so nicely. My other
> formulas are easily "rattled" should I try and touch the formatting of
> the sheets cells.
>
> Is there any other functions I can use that will give me what I want?
>
> Regards
> Sonar
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile:
http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>

You can use 'trim' or 'value' to force the key value to the needed type to
work inside the vlookup. Ex: =vlookup(value(a10),Mo!$a:$d,4,false) if the
values in column A on the Mo worksheet are numeric but cell a10 contains
text. =vlookup(trim(a10),Mo!$a:$d,4,false) should work in the opposite case.

As others noted, this all requires that your values in column A on the Mo
worksheet are unique. Otherwise vlookup would NOT be a suitable replacement
for sumif.


"sonar" wrote:

>
> my 13 digit numbers only works in cells formated as Text, unfortunatly,
> if I try to have them any other way, the other formula that puts in the
> description, does not work.
>
> Vlookup does not want to match up text formulated info with General
> formulated info.
>
> I know that Sumif calc. information, but it works where vlookup does
> not. The problem is, I dont want it to calculate.
>
> Any idea what I can use here?
>
> Regards
>
>
> --
> sonar
> ------------------------------------------------------------------------
> sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
> View this thread: http://www.excelforum.com/showthread...hreadid=401265
>
>