Find text & return next cell from non-adjacent table data

[katiecolorado]

I am looking to find the cell data next to a given input. The tricky part is the data in not in one table however several tables. Is there a formula to look for "2.000.001" and return "Magnolia Tree 1"?

 

[Cubist]

In cell K5, try:

=TOCOL(IF($B$3:$G$21=J5,$A$3:$F$21,NA()),2)

 

[Cubist]

I swapped the ranges above. It should be

=TOCOL(IF($A$3:$F$21=J5,$B$3:$G$21,NA()),2)

 

[katiecolorado]

Thank you!