I need to compare two columns and see if any row has two specified values adjacent

I'm working on a spreadsheet that determines the total resistance of any complex circuit. I am trying to figure out a way to determine what row has two specified values within two columns. For example, Two columns have numbers 0-3. Each number shows up 3 times within the two columns matching up with each of the other numbers once. (See Column C and D "Node 1", "Node 2"). Next to those columns is a column for current.

On the lower portion of the spreadsheet is a table in red with numbers going vertically and horizontally. I want to know the value of the current where the vertical and horizontal numbers match up. For example.

0-0 would read NA
0-1 would read 0.055555556
0-2 would read 0.019736842

And so on.

P.S. Theoretically I will be adding something that will make the current negative or positive according to which voltage is higher, but I can figure that out on my own. I need help with the first part.

Thanks!

I thought I posted the spreadsheet, sorry. Hopefully this works now

Hello
Take a look at the attached reply. Does this do as required? I've created three named ranges to make it clearer and used an array formula, these are entered with Ctrl+Shift+Enter. The formulas match Node 2 to Node 1 for the values 0-3.

DBY

@DBY

Yes, perfect! Any suggestions on how to get the rest of the values since the nodes in the columns vary in sides. For example, 0 never shows up on the left side.

I do not want to put any critical guidelines regarding how the nodes are input. I'd like excel to read any possible input.

Thanks so much

Glenn, that looks right as well! I simply need the values in that table so I can extract information from it! Thank you very much!

In J12

=IFERROR(INDEX($E$2:$E$7,MATCH(1,($I12=$C$2:$C$7)*(J$11=$D$2:$D$7),0)),IFERROR(INDEX($E$2:$E$7,MATCH(1,($I12=$D$2:$D$7)*(J$11=$C$2:$C$7),0)),""))

Enter with Ctrl+Shift+Enter

Copy across and down

They both have the idea I was looking for with different approaches. Yours suited my needs best.