Dear Pawan,
Problem solved thanks for help
Regards
Shrinivas
On Sat, Dec 26, 2015 at 9:40 AM, Shrinivas Shevde
wrote:
> Dear Pawan
> Very very thanks I will check on Monday As I am out of office and let you
> know.
> Thanks once again
> Regards
> Shrinivas
>
> On Wed, Dec 23, 2015 at 5:18 PM,
Dear Pawan
Very very thanks I will check on Monday As I am out of office and let you
know.
Thanks once again
Regards
Shrinivas
On Wed, Dec 23, 2015 at 5:18 PM, Pawan Yadav wrote:
> Hi Shrini,
>
> Use this formula instead =>
> *=VLOOKUP(IFERROR(ABS(C2),C2),$H$7:$I$17,2,FALSE) *
>
> Problem: ABS f
Hi Shrini,
Use this formula instead =>
*=VLOOKUP(IFERROR(ABS(C2),C2),$H$7:$I$17,2,FALSE) *
Problem: ABS formula is not for Text value so it will return #Value
Solution: As you lookup value consist both number and text value, so if you
want to use ABS formula than use the above formula.
If you
>
> Some values in both tables are text and some are integers, You will get
> Error for those only when text value is comparing with Integer. For correct
> result you need to keep the format same.
>
*To understand this activity Do this to understand *
Put 1 in cell A1
put formula in b1 = Text
Dear Mandeep
thanks for reply but I could not understand which format shall I change
which column
Regards
Shrinivas
On Mon, Nov 30, 2015 at 10:34 AM, Mandeep Baluja
wrote:
> Keep the data in same format, number can't be equal to Text and text can't
>> be equal to number,I put the data in same f
shrini check this
http://excelautomate.blogspot.in/2013/12/lookups-and-tables.html
On Wednesday, 20 November 2013 17:10:46 UTC+5:30, shrini wrote:
>
> Dear All
> Please find attached query.
> Is it possible to write aformula as per my requirement
>
> --
> Shrini
>
--
Are you =EXP(E:RT) or =NO
Dear shakeel
thanks
problem solved great Help
Regards
Shrinivas
On Thu, Nov 21, 2013 at 1:51 PM, Shakeel Dhanani wrote:
>
> You can use Index Match formula instead of VLookup as per Fiel atatched
>
> On Wednesday, November 20, 2013 4:40:46 PM UTC+5, shrini wrote:
>>
>> Dear All
>> Please find at
You can use Index Match formula instead of VLookup as per Fiel atatched
On Wednesday, November 20, 2013 4:40:46 PM UTC+5, shrini wrote:
>
> Dear All
> Please find attached query.
> Is it possible to write aformula as per my requirement
>
> --
> Shrini
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT
Hi Noorain,
Correct me if I am wrong. What you are trying to do in this function
is to bring up the relevant data from 3 different worksheets. In the
event, that one worksheet does not have the data, the formula will
cycle through to the other worksheet. However, using the OR function
here will no
