Help with the formula!!
ok I have 3 columns in Sheet2 (or maybe more in the future).
I have 2 worksheets. One for the lookup formula-> Sheet1 and Sheet 2
for all the data such as the area code->A, salesrep->B and region ->C.

On Sheet 1, A2, I typed the formula
VLOOKUP(A1,area2!$A$2:$C$295,2,FALSE)
But it's only giving me the salesrep, I also want the region.
How do I change my formula to include the region as well, AND maybe
I'll add more columns such as phone numbers of the salesreps, how can I
change my formula to look up more columns when I type a single area
code?

thanks!
I hope I made myself clear...