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