Dear All

I have problem in designing my Vlook up table, I pull up information from my internal Data base- In this data base there are Various column from A-R
ColumnA giving the name of the deport ,column B Route number ,column C fare rate,coulmn D fare stage number, and others to column R

What I need to do is that to allocate number of passengers boarding on a bus at each fare stage number by borough council-the routes operates across borough council

I create another table , I named it as Borough council master file, in this file there are three column A-C, Column A Route number, Column B Fare stage number, and Column C Borough council name

What I need to do is to Create V look up table and link these two sheets , then run Pivot table to get number of passengers by Borough councils

The question is how to write the V look up formular ? so as I can get the number of passengers by Borough council

I need your help

Thank you


Wahiba