Rude Awakening
New member
- Joined
- Nov 4, 2013
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365
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.
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.
View attachment 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
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.
View attachment 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