Index Match in Excel

When you have:

1 sheet called: Data
1 sheet called: Ref

• In Data you want to enter a value that came from worksheet Ref in:
  column C has the keys
  column G has the values

and you want to have based on a value in sheet Data the value from G based on key C

then you can use: =INDEX(Ref!G1:G100;MATCH(D3;Ref!C1:C100;0)) in the cell in sheet Data

that is: = INDEX(list to return value from;MATCH(value to look for;list with index to look for;0);