Good evening,
I need help creating an excel formula that searches for the "component" name and extracts each value for the following: "AF Worst Case Working", "AF Worst Case Incident", Voltage (V), "AF Worst Case Boundary", "AF_LimitedApproach", through "AF_BoltedFault (kA)". Refer to snapshot 1. The extracted information would then go into a separate excel file. Refer to Snapshot 2.
I tried using index(match()), hlookup(), and vlookup(), but I haven't been successful with these commands to give me what I needed to see.
Snapshot 1:
Snapshot 2:
Any advice would help.
Thank you.
I need help creating an excel formula that searches for the "component" name and extracts each value for the following: "AF Worst Case Working", "AF Worst Case Incident", Voltage (V), "AF Worst Case Boundary", "AF_LimitedApproach", through "AF_BoltedFault (kA)". Refer to snapshot 1. The extracted information would then go into a separate excel file. Refer to Snapshot 2.
I tried using index(match()), hlookup(), and vlookup(), but I haven't been successful with these commands to give me what I needed to see.
Snapshot 1:
Snapshot 2:
Any advice would help.
Thank you.