IF Statement, or Vlookup?? HELP

Example6.xlsx

Hi,

this is probably a very simple one, i just cant remember what it is im meant to be using as i havnt done it since school.

basicly on the attached spreadsheet, there are 2 tabs.

the common column is Contract number,

if the data in the contract number column matches then i need the figures for 20/40/TEU to show against the Special aggreement by code tab.

any sugestions would be welcome.

thanks

IMO, use of Index/match is more suitable as vlookup only look for left most column but you can use index/match for any column ..... but in your case Vlookup will also work fine ......