+ Reply to Thread
Results 1 to 10 of 10

How to Update the Worksheets field value based on updates done in Main Worksheet.

Hybrid View

arunsinghpundir How to Update the Worksheets... 10-08-2007, 10:50 AM
NBVC To me it looks like you are... 10-08-2007, 12:45 PM
arunsinghpundir Hello NBVC. Thanks for a... 10-09-2007, 05:14 AM
NBVC With alphanumeric or alpha... 10-09-2007, 07:46 AM
arunsinghpundir Hello NBVC Thanks again... 10-09-2007, 09:00 AM
NBVC The #N/A formula was due to... 10-09-2007, 09:08 AM
arunsinghpundir Hello NBVC Thanks again... 10-09-2007, 10:01 AM
NBVC You should only enter the... 10-09-2007, 10:46 AM
arunsinghpundir Hello NBVC - Perfect... 10-10-2007, 03:06 AM
NBVC Unfortunately, Excel does not... 10-10-2007, 07:44 AM
  1. 10-09-2007, 10:01 AM #1
    arunsinghpundir is offline
    Registered User
    Join Date
    03-05-2007
    Posts
    12
    Hello NBVC

    Thanks again ...If i use just reference the item in column A of sheets B and C and not enter the string into the formula then in worksheet "B" it is taking the refrence of "A2" column of worksheet "B" only and not of the worksheet "A".
    Similarly in worksheet "C" it is taking the refrence of "A2" column of worksheet "C" only and not of the worksheet "A".
    but if i enter the string into the formula then then it seems to be working ...
    kindly let me know whats the problem .......as i myself don't wana use string into the formula...kindly help!

    Thanks again for helping me out.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-09-2007, 10:46 AM #2
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    You should only enter the formula in the first row (C2) and then copy down the formula, this will automatically change the reference to column A to coincide with the next entry in A.

    To copy the formula down, click and hold the little black square at the bottom right corner of the active cell and drag it down the column.

    See attached.
    Attached Files Attached Files
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
    Reply With QuoteRegister To Reply
  3. 10-10-2007, 03:06 AM #3
    arunsinghpundir is offline
    Registered User
    Join Date
    03-05-2007
    Posts
    12
    Hello NBVC -

    Perfect ...thats what i was looking for and it helped .But one more issue related to the same, as in Worksheet "B" there are some entries in column "A" which are not present in column "A" of Worksheet "A" ,then i want to keep the value of column "C" in Worksheet "B" intact.

    Currently if i use =VLOOKUP(A2,'Sheet A'!$A$2:$C$8,3,0) in worksheet "B" under column "C" then for unmatached records it is displaying the value as "#NA".
    I want to search the value of Column "A" of worksheet "B" in Column "A" of worksheet "A" and if a matach is found then update the value of Column "C" of worksheet "B" otherwise keep the value of Column "C" of worksheet "B" as what is mentioned.
    Please help.
    Thanks again for helping me out.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 10-10-2007, 07:44 AM #4
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Unfortunately, Excel does not allow you to choose a formula result or leave the cell "untouched" (unless you get into programming it with VBA).

    What I can suggest is that you include another column with a new formula that will look for a match first and if it is not found, then it will take from the original State column.....

    See sample attached...formula in D2 copied down is: 
    =IF(ISNA(VLOOKUP(A2,'Sheet A'!$A$2:$C$8,3,0)),C2,VLOOKUP(A2,'Sheet A'!$A$2:$C$8,3,0))
    I hope this works for you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1