Vlookup multiple ways

Hi im wanting to do a lookup from a number of cells.
(cell a) bone is already a VLOOKUP formula cell
(cell b) the other is a number I will type in.
I want (cell c) to go to a table and match both requisites and if then I change cell b to then correspond etc... help!

Can you upload your workbook? It will make coming up with a solution much easier.

workbook 1.xlsx

the attachment

Dear kheino1111,
I am unable to follow exactly what you would like to achieve - can you please exemplify your requirement (and attach a sample spreadsheet with the details). This would enable everyone to comprehend your request & help them help you in turn.

Warm regards,
Jewel

im new and don't know how to add my file

what I want to happen is:

when I type in a paddock name (that matches a paddock in the rotation sheet) & type in a year it will bring up value

Like this?

yes but only need to have the one paddock name as in my other spreadsheet the paddock name is linked with the sheet name and then linked via a vlookup formula to the rotation spreadsheet.
I will be wanting to add the years across

No problem! Just change the cell reference for the second cell to the first paddock name

Thankyou sooooo much!!!

im about to post another question and would love your help!