I have created a table on Sheet1
Reference to Lookup is in Sheet2, wherein the entire table range has been named Table
Now in Sheet1 I want to create a formula based on range name but there seems to be an error in the formula which I cannot figure it out.
The Formula I want to create is in Sheet1 Row C
The formula should lookup the value in Row B, and put the correct figure from Sheet2, row D
What I want is shown from C6 onwards. I want to create a formula based on Range named as Table
The formula I have used us shown in Sheet1, Cell C3 that has a error
Attached file for reference