+ Reply to Thread
Results 1 to 9 of 9

I need a formula to copy a cell from a specific column (range of values) when 4 other cond

  1. 01-24-2023, 07:15 AM #1
    gsnaor
    gsnaor is offline
    Registered User
    Join Date
    01-24-2023
    Location
    Romania
    MS-Off Ver
    Version 2108
    Posts
    5

    Exclamation I need a formula to copy a cell from a specific column (range of values) when 4 other cond

    Hello, I need a formula to copy a cell from a specific column (range of values) when 4 other conditions are correct (I used 4 IFs).
    As an example, in column A I have multiple values (0,0,0,0,0,0), in column B I have (4,4,4,5,5,5,.....), in column C I have (1,1,3,3,5,5,......) and in column F I have a text (SINGLE_RET,SINGLE_RET,STMA,SINGLE_RET,,STMA,SINGLE_RET,....) and I am looking for a formula to copy the cell from column G (Vendor Code) of the position when all the others are correct...

    =IF(B2=VLOOKUP(B2,'SCN ALD'!A3:A200,1,FALSE),IF(B3=VLOOKUP(B3,'SCN ALD'!B3:B200,1,FALSE),IF(B4=VLOOKUP(B4,'SCN ALD'!C3:C200,1,FALSE),IF(C12=VLOOKUP(C12,'SCN ALD'!F3:F200,1,FALSE),
    ------- here is the missing part of the formula--------




    Copy of the excel file:

    Control Port Cabinet No. Control Port Subrack No. Control Port Slot No. Control Port No. Result ALD Device Type Vendor Code

    0 4 1 R0A SUCCESS SINGLE_RET HW
    0 4 1 R0A SUCCESS SINGLE_RET HW
    0 4 1 R0A SUCCESS STMA HW
    0 4 1 R0A SUCCESS SINGLE_RET HW
    0 4 1 R0A SUCCESS SINGLE_RET HW
    0 4 1 R0A SUCCESS SINGLE_RET HW
    0 4 1 R0A SUCCESS SINGLE_RET HW
    0 4 3 R0A SUCCESS SINGLE_RET HW
    0 4 3 R0A SUCCESS SINGLE_RET HW
    0 4 3 R0A SUCCESS STMA HW
    0 4 3 R0A SUCCESS SINGLE_RET HW
    0 4 3 R0A SUCCESS SINGLE_RET HW
    0 4 3 R0A SUCCESS SINGLE_RET HW
    0 4 3 R0A SUCCESS SINGLE_RET HW
    0 4 5 R0A SUCCESS SINGLE_RET HW
    0 4 5 R0A SUCCESS SINGLE_RET HW
    0 4 5 R0A SUCCESS STMA HW
    0 4 5 R0A SUCCESS SINGLE_RET HW
    0 4 5 R0A SUCCESS SINGLE_RET HW
    0 4 5 R0A SUCCESS SINGLE_RET HW
    0 4 5 R0A SUCCESS SINGLE_RET HW
    0 5 1 R0A SUCCESS STMA KA
    0 5 3 R0A SUCCESS STMA KA
    0 5 5 R0A SUCCESS STMA KA
    0 90 0 R0A SUCCESS STMA HW
    0 91 0 R0A SUCCESS STMA HW
    0 92 0 R0A SUCCESS STMA HW
    0 210 0 NULL FAILURE NULL NULL
    0 211 0 NULL FAILURE NULL NULL
    0 212 0 NULL FAILURE NULL NULL
    Reply With QuoteRegister To Reply
  2. 01-24-2023, 07:16 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: I need a formula to copy a cell from a specific column (range of values) when 4 other

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 01-24-2023, 07:39 AM #3
    gsnaor
    gsnaor is offline
    Registered User
    Join Date
    01-24-2023
    Location
    Romania
    MS-Off Ver
    Version 2108
    Posts
    5

    Re: I need a formula to copy a cell from a specific column (range of values) when 4 other

    Attachment 814707Attachment 814708 -> Attached pictures
    Reply With QuoteRegister To Reply
  4. 01-24-2023, 07:42 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: I need a formula to copy a cell from a specific column (range of values) when 4 other

    I wanted an Excel file... not a non-editable PICTURE or one...
    Reply With QuoteRegister To Reply
  5. 01-24-2023, 07:47 AM #5
    gsnaor
    gsnaor is offline
    Registered User
    Join Date
    01-24-2023
    Location
    Romania
    MS-Off Ver
    Version 2108
    Posts
    5

    Re: I need a formula to copy a cell from a specific column (range of values) when 4 other

    Attachment 814710 here is the excel file, sorry Glenn...
    Reply With QuoteRegister To Reply
  6. 01-24-2023, 09:46 AM #6
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: I need a formula to copy a cell from a specific column (range of values) when 4 other

    Nope. it dodn't attach properly.


    For a new post in your existing thread click on Go Advanced (below the Edit Window) while composing your reply, then scroll down to and click on Manage Attachments. The Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
    Reply With QuoteRegister To Reply
  7. 01-24-2023, 09:49 AM #7
    gsnaor
    gsnaor is offline
    Registered User
    Join Date
    01-24-2023
    Location
    Romania
    MS-Off Ver
    Version 2108
    Posts
    5

    Re: I need a formula to copy a cell from a specific column (range of values) when 4 other

    exemple.xlsx what about now?
    Reply With QuoteRegister To Reply
  8. 01-26-2023, 03:48 AM #8
    gsnaor
    gsnaor is offline
    Registered User
    Join Date
    01-24-2023
    Location
    Romania
    MS-Off Ver
    Version 2108
    Posts
    5

    Re: I need a formula to copy a cell from a specific column (range of values) when 4 other

    Hi Glenn, good morning, do you have any idea for this case? Thank you in advance!
    Reply With QuoteRegister To Reply
  9. 01-27-2023, 05:58 AM #9
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: I need a formula to copy a cell from a specific column (range of values) when 4 other

    No, it's not clear. A bit of a guess!!

    =INDEX('SCN ALD'!$G$3:$G$40,MATCH(1,('SCN ALD'!$A$3:$A$40='Add RET'!B2)*('SCN ALD'!$B$3:$B$40='Add RET'!B3)*('SCN ALD'!$C$3:$C$40='Add RET'!B4)*('SCN ALD'!F3:$F$40='Add RET'!C12)*(ISNUMBER(SEARCH(B10,'SCN ALD'!$H$3:$H$40))),0))

    in c13???????????
    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)

Similar Threads

  1. [SOLVED] Find a specific cell in a row and copy and paste value into a given range of its column.
    By Thomas Stein in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2021, 03:44 PM
  2. VBA Copy specific Range with values to new worksheet with name based cell
    By PaulaGon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2018, 12:44 PM
  3. [SOLVED] Copy cells in a specific range or column if cell value is greater/less than a value?
    By Kamal1234 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-07-2018, 11:30 AM
  4. Copy data from one row to another sheets row if specific values are entered in cell range
    By bwwalker in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2015, 11:05 AM
  5. [SOLVED] How to select all cells to the last cell in a specific column and copy values
    By pasqualebaldi in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-15-2014, 11:44 AM
  6. [SOLVED] Copy and paste values of specific column and increase a cell value by 1
    By ncalvelo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-20-2013, 10:38 AM
  7. [SOLVED] Cond. formatting a column/Range, highlight cell in column/range if equal to specific text
    By DFrank231 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2013, 03:35 PM

Tags for this Thread

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