how i can apply vlookup fomula if some figure are rpeated in the l

[vlook fomula]

i have data on a sheet and i am applying vlookup formula with
if(isna(vlookup....2,0) but it is taking 1st figure from the list if the
figures are repeated then i am applying sumif formula on specific line for is
there any easy way to apply uniform formula if the some figures are rpeated
in the list?

 

[CyberTaz]

Well, that's basically how VLOOKUP works. The lookup values are expected to
be unique. It stops searching once it finds what it's looking for & can only
return one value. I get the impression that there may be a better way to
accomplish what you're attempting to do but what that is isn't at all clear.

If you can provide a concise description of what you're attempting to do &
what the nature of your data is perhaps someone can offer a suggestion. Make
sure to specify what version of Excel you're using (specific update level)
as well as what version of OS X... Although the source of your post suggests
that you're actually using a Windows version on a PC [This is the Mac Excel
forum.]. If so, you're still welcome to continue here or you may prefer to
go to one of the PC Excel groups @:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[vlook fomula]

thanks i got result with application of sumif
my 2nd quesion is that can we display all formula on the sheet please help
me because.

It is observed that if we had link one sheet to another sheet with the help
of vlookup formula than if it is with in the one file that ok if liked with
another file then its need update of likes when we open this file. Is there
any way for tracing liked formula in a sheet while it has so many data?

Thanks
Zafar

Well, that's basically how VLOOKUP works. The lookup values are expected to
be unique. It stops searching once it finds what it's looking for & can only
return one value. I get the impression that there may be a better way to
accomplish what you're attempting to do but what that is isn't at all clear.

If you can provide a concise description of what you're attempting to do &
what the nature of your data is perhaps someone can offer a suggestion. Make
sure to specify what version of Excel you're using (specific update level)
as well as what version of OS X... Although the source of your post suggests
that you're actually using a Windows version on a PC [This is the Mac Excel
forum.]. If so, you're still welcome to continue here or you may prefer to
go to one of the PC Excel groups @:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

Regards |:>)
Bob Jones
[MVP] Office:Mac

i have data on a sheet and i am applying vlookup formula with
if(isna(vlookup....2,0) but it is taking 1st figure from the list if the
figures are repeated then i am applying sumif formula on specific line for is
there any easy way to apply uniform formula if the some figures are rpeated
in the list?

 

[CyberTaz]

There are at least 2 ways I can think of:

In Excel> Preferences> View you can check the box for Show Formulas. That
displays *all* formulas for what they are rather than their results which
can be a bit overpowering.

A better option may be to select the cell containing the formula you're
interested I, then go to Tools> Auditing> Trace Precedents. If the precedent
cells also contain formulas click the button again to trace those. In
addition to the various Auditing commands there is also an Auditing Toolbar
you can turn on & the commands can have keystrokes assigned if you wish. See
Excel Help on the topic: "Find errors in formulas and cells" for details.

HTH |:>)
Bob Jones
[MVP] Office:Mac

thanks i got result with application of sumif
my 2nd quesion is that can we display all formula on the sheet please help
me because.

It is observed that if we had link one sheet to another sheet with the help
of vlookup formula than if it is with in the one file that ok if liked with
another file then its need update of likes when we open this file. Is there
any way for tracing liked formula in a sheet while it has so many data?

Thanks
Zafar

Well, that's basically how VLOOKUP works. The lookup values are expected to
be unique. It stops searching once it finds what it's looking for & can only
return one value. I get the impression that there may be a better way to
accomplish what you're attempting to do but what that is isn't at all clear.

If you can provide a concise description of what you're attempting to do &
what the nature of your data is perhaps someone can offer a suggestion. Make
sure to specify what version of Excel you're using (specific update level)
as well as what version of OS X... Although the source of your post suggests
that you're actually using a Windows version on a PC [This is the Mac Excel
forum.]. If so, you're still welcome to continue here or you may prefer to
go to one of the PC Excel groups @:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

Regards |:>)
Bob Jones
[MVP] Office:Mac

i have data on a sheet and i am applying vlookup formula with
if(isna(vlookup....2,0) but it is taking 1st figure from the list if the
figures are repeated then i am applying sumif formula on specific line for
is
there any easy way to apply uniform formula if the some figures are rpeated
in the list?