Function help, (logic?) assigning a value to a cell based on another

[jdcollins88]

Hello, I am trying to fill in the Net height in the below table based on the Net assignment located next to species. If Net=A then Net height should = 2.6 for MYLU but should be 10.4 for MYSO. I've tried a nested IF function =IF(B1="A",C1 IF(B1="B", D1)) but it returns an error. I could do it by hand if I didn't have 10K records

Species	Net	Net A Height	Net B Height	Net Height
MYLU	A	2.6	5.2
MYSO	A	10.4	10.4
MYSE	B	5.2	2.6
MYSE	A	10.4	2.6

<tbody>
</tbody>

Thanks for the help.
Jason

 

[Special-K99]

This is a little unclear.

Try
=IF(AND(A1="MYLU",B1=2.6),5.2,IF(AND(A1="MYSO",B1=10.4),10.4,2.6))

 

[jdcollins88]

The reality is a bit more complex I was trying to keep it as simple as possible. Basically the "net" and net height are appended tables, and the species are coming from different locations meaning net A is not always the same length, but the net heights correspond to the height of those nets (e.g. A, B) at that location. The end result would be two columns one with species and one with the height of the net that species was captured in. So if species X was captured in net C I want to assign it the height designated in the corresponding column titled net C. I hope this clears it up a bit.