+ Reply to Thread
Results 1 to 2 of 2

Google sheet copy paste work with condition of two value match

  1. 03-02-2024, 03:08 AM #1
    Bhavesh780
    Bhavesh780 is offline
    Registered User
    Join Date
    06-16-2021
    Location
    India
    MS-Off Ver
    Microsoft® Excel® 2019 MSO (16.0.14131.20000) 64-bit
    Posts
    10

    Google sheet copy paste work with condition of two value match

    Take or copy data from column C and paste to column F only with condition that column A match with D and B match with Column E

    Note column A and B has row till 1382 and coulmn D and E has 1912

    I used formula =ARRAYFORMULA(IF((A2:A<>"") * (B2:B<>""), IFERROR(VLOOKUP(A2:A&B2:B, D$2:E$1382, 2, FALSE), ""), "")) Error Array result was not expanded because it would overwrite data in F3.

    =ARRAYFORMULA(IF((A2:A<>"") * (B2:B<>""), IF(ISBLANK(F2:F), IFERROR(VLOOKUP(A2:A&B2:B, D$2:E$1382, 2, FALSE), ""), ""), "")) Error Circular dependency detected. To resolve with iterative calculation, see File > Settings.


    This is simple for Google sheet expert kindly try to put data in Google sheet please don't just say here is the formula try yourself coz that things not work for me might format issue

    I'm providing Editable sheet (I'm restricted to post link so just copy paste this link in your browser) docs.google.com/spreadsheets/d/1iL27FsuC3X3wzfWPBs885ief58hZ6I71b4lwgbn2ZrU/edit?usp=sharing
    Thank you so much
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-02-2024, 03:30 PM #2
    janmorris
    janmorris is offline
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Google sheet copy paste work with condition of two value match

    Hi Bhavesh780.

    You can do that with some helper columns (the formula can fail if try to do without the helper columns).

    Joining A:B
    =MAP(A2:A,B2:B,LAMBDA(adates,bprices,IF(adates="",,JOIN("-",adates,bprices))))

    Joining D:E
    =MAP(D2:D,E2:E,LAMBDA(ddates,eprices,IF(ddates="",,JOIN("-",ddates,eprices))))

    Then the VLOOKUP for column F:
    =BYROW(H2:H,LAMBDA(source,IF(source="",,IFERROR(VLOOKUP(source,{G2:G,C2:C},2,0)))))
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
    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)

Similar Threads

  1. Google sheet, wish to copy paste data from a sheet to another reference from two column
    By Bhavesh780 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 03-03-2024, 06:58 PM
  2. Google sheet copy paste work with condition of two value match
    By Bhavesh780 in forum Excel General
    Replies: 0
    Last Post: 03-02-2024, 03:08 AM
  3. Google sheet, wish to copy paste data from a sheet to another reference from two column
    By Bhavesh780 in forum Excel General
    Replies: 0
    Last Post: 03-01-2024, 07:26 AM
  4. (Google App Scripts) Copy and paste value for all Google Sheets contained in one folder
    By bobbiekan in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 09-29-2021, 11:48 PM
  5. Google Sheets: Condition formatting in Google sheet
    By cyee in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 02-18-2021, 05:35 PM
  6. Google sheet: copy and paste column in exact format not working
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 06-28-2020, 04:17 AM
  7. [SOLVED] Copy paste to another sheet only once when the condition is met
    By ecelebi16 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-09-2019, 11:11 AM

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