Lookup cell entry on header row, search within that column for another entry return adjace

[Caraexcel]

Good Evening,

I am making a livestock entry form. My data is in the data tab.

I have it so if I enter the division number (L) on the Entry tab it returns the specie (M) from the data tab.

What I can't figure out is for Column O (Class Name). I need it to look up the specie selected (Beef for M2) on row 1 of the Data tab which would be Column E for beef. Then I need it to look within that selected column and find the entered entry Class (N from the Entry tab) and return the adjacent data (Class Name) which would be "Senior Bull Calf" in this specific situation.

Columns L M N O
For second row would be 100 Beef 09 Senior Bull Calf
For the next entry it would be 105 Swine 07 Homegrown Swine

I have tried Xlookup, Vlookup, If and others I thought might work but I can't seem to get it.

Thank you,
Cara

[protonLeah]

.....Your table names, range names and column headers are conflicting and confusing.
.....I deleted all of those one column tables and created two column tables in their places, e.g. beef/beefnames, etc.,
using the upper left cell value as the name.

.....I had to use he INDIRECT function in the data validation formulas for Entry column L (divisions):

Please Login or Register  to view this content.

Return species to column M with:

Please Login or Register  to view this content.

Meat ID (column N, data validation):

Please Login or Register  to view this content.

Meat description (col O):

Please Login or Register  to view this content.

[Caraexcel]

Thank you sooo much, you did exactly what I wanted and so much more. I cannot begin to tell you how much I appreciate this. Thank you also for taking the time clean it up and showing what you did in each area to assist me in learning. Thank you I was ready to cry in frustration.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.