Hi,
I am trying to link one table 1 with another table 2, and these are in different tabs.

In first table (1) I have to do some calculations, and in the second table (2) I have contacts (name, fax and contact name).

So I want from first table once I write the name of Trade (which I did with data validation to pick only the trades that are in table 2 from A1 to A50) to populate table 1 - columns B with Contact Name and Column C with Fax # and all these data should come from table 2.

I tried with Vlookup but the problem is that I can fill only column B and I need to fill column B and C in the same time?

Is this possible in Excel or the only way is to go to MS Access?