• WSprasad

    WSprasad

    @wsprasad

    Viewing 15 replies - 1 through 15 (of 256 total)
    1 2 3 … 16 17 18
    Author
    Replies
    • WSprasad
      AskWoody Lounger
      January 27, 2010 at 6:19 am in reply to: Conditional Lookup based on two values #1206893

      There are several possibilities of IF with And, Match & Index or Sumproduct. Can you attach a copy with sensitive data removed.

    • WSprasad
      AskWoody Lounger
      January 25, 2010 at 5:11 am in reply to: Text LookUp More Than One Condition #1206606

      Hi there,

      I need someone’s help, for a formula in result column in Table 1 as attached file, to pick up text in result column in Table 2.

      Thanks and regards

      Indra

      try this array formula in C3 (confirm with Ctrl + Shift + Enter)

      =INDEX($C$10:$C$15,MATCH(1,($A$10:$A$15=A3)*($B$10:$B$15=B3),0))

    • WSprasad
      AskWoody Lounger
      January 14, 2010 at 1:54 am in reply to: Logical Function with Vlookup #1201439

      One possible workaround is to check it for “N/A”. Try this :

      Code:
      =IF(ISERROR(IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3))),0,IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3)))
    • WSprasad
      AskWoody Lounger
      January 14, 2010 at 1:54 am in reply to: Logical Function with Vlookup #1202252

      One possible workaround is to check it for “N/A”. Try this :

      Code:
      =IF(ISERROR(IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3))),0,IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3)))
    • WSprasad
      AskWoody Lounger
      January 14, 2010 at 1:54 am in reply to: Logical Function with Vlookup #1203056

      One possible workaround is to check it for “N/A”. Try this :

      Code:
      =IF(ISERROR(IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3))),0,IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3)))
    • WSprasad
      AskWoody Lounger
      January 14, 2010 at 1:54 am in reply to: Logical Function with Vlookup #1203947

      One possible workaround is to check it for “N/A”. Try this :

      Code:
      =IF(ISERROR(IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3))),0,IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3)))
    • WSprasad
      AskWoody Lounger
      January 14, 2010 at 1:54 am in reply to: Logical Function with Vlookup #1198261

      One possible workaround is to check it for “N/A”. Try this :

      Code:
      =IF(ISERROR(IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3))),0,IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3)))
    • WSprasad
      AskWoody Lounger
      January 14, 2010 at 1:54 am in reply to: Logical Function with Vlookup #1199027

      One possible workaround is to check it for “N/A”. Try this :

      Code:
      =IF(ISERROR(IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3))),0,IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3)))
    • WSprasad
      AskWoody Lounger
      January 14, 2010 at 1:54 am in reply to: Logical Function with Vlookup #1199769

      One possible workaround is to check it for “N/A”. Try this :

      Code:
      =IF(ISERROR(IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3))),0,IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3)))
    • WSprasad
      AskWoody Lounger
      January 14, 2010 at 1:54 am in reply to: Logical Function with Vlookup #1200558

      One possible workaround is to check it for “N/A”. Try this :

      Code:
      =IF(ISERROR(IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3))),0,IF(D18>0,Commission(D18+D16,D17)+VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3),VLOOKUP(D14,Front_end_Dale,3)+VLOOKUP(D15,BackEnd_dale,3)))
    • WSprasad
      AskWoody Lounger
      January 9, 2010 at 5:53 am in reply to: Cell show formula not result #1196933

      if you put an apostrophe as the first character

      It converts the inputs in to plain text. can viewed in formula bar.

      in addition, holding down ~with Ctrl key shows formula itself instead of results and vice versa.

    • WSprasad
      AskWoody Lounger
      January 8, 2010 at 3:51 am in reply to: Password protected files #1196540

      stuck…

      installed .Net Framework, installed the PW cracker & it took a whole day on a XP machine without any result.

    • WSprasad
      AskWoody Lounger
      January 8, 2010 at 1:51 am in reply to: Filling a cell from one worksheet to another #1196528

      Can anyone help out with the formula or solution for this.

      A little more explanation with stripped down copy, if possible, is required to know what exactly you are looking for.

    • WSprasad
      AskWoody Lounger
      January 7, 2010 at 6:24 am in reply to: Cell reference problem (EXcel 2003 SP3) #1195992

      See if this could help you.

    • WSprasad
      AskWoody Lounger
      January 7, 2010 at 5:55 am in reply to: Cell reference problem (EXcel 2003 SP3) #1195989

      so I tried a replace for all of the worksheets to replace $ with nothing and it says it has made 27,000+ changes but then hangs until Excel says it has stopped responding.

      I would prefer to let the excel perform the task its own way. Not responding message appears on interruption only.

      BTW, are you trying to replace the contents for all the ws’s in one go?

    Viewing 15 replies - 1 through 15 (of 256 total)
    1 2 3 … 16 17 18
  • « Older Entries
DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.