Results 1 to 3 of 3

Thread: Look up cell value in one sheet, if found post other cell value to another sheet

  1. #1

    Look up cell value in one sheet, if found post other cell value to another sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hey Guys
    Having an issue with a SS, wondering if someone can help.

    I need to look up the "Test case ID number (=BARC!E2)" from the BARC sheet to the "Summary sheet" and if a match is found do three separate things. I am aware these require three separate but similar formulas.


    • Insert the "Test Description" from the Summary sheet into the "Test Case" area of the BARC sheet.
    • Insert the "Reconciliation" from the Summary sheet into the "Reconciliation" area of the BARC sheet.
    • Insert the "Category" from the Summary sheet into the "Category" area of the BARC sheet.


    As an example, search BARC-POS-1.1.01 (=BARC!E2) in Summary sheet,
    Where found in "Summary sheet"
    insert "Description" 'Summary Sheet'!A3 into 'BARC'!B2,
    insert "Reconciliation" 'Summary Sheet'!B3 into 'BARC'!E4
    insert "Category" 'Summary Sheet'!A3 into 'BARC'!D4


    I have tried various IF(ISERROR statements similar to Col E-H in Summary Sheet but have been unsuccessful.

    Test Case V2.0 - Copy.xls

    I've had to delete alot of contents as the file was too big, but the Col E-H formula does work
    Appreciate any assistance
    RA

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,499
    Articles
    0
    Excel Version
    Excel 2016
    In B2:

    =IF(ISNA(MATCH(E2,'Summary Sheet'!$C:$C,0)),"",INDEX('Summary Sheet'!A:A,MATCH(E2,'Summary Sheet'!$C:$C,0)))

    and similar in other cells subbing the 'Summary Sheet'!A:A for the column containing the information of interest.


  3. #3
    Worked like a charm.
    Thanks a mill.
    Sorry abt the late reply

Posting Permissions

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