Vlookup from Access

[MitzDriver]

In excel I need to enter a number into a1 (serial #), return to a2 the
Corresponding data from access table to a2 [Deal Name] and from access to a3
[form #].

Should i use =vlookup(a1,'access table',?) or what?

If this makes no sense let me know and I will try again. Trying to follow
the rules and make it short and sweet.

ANY help would be very appreciated.

 

[MitzDriver]

Thank you for replying.

Yes, I am looking to return a result from an Access database into a cell in
Excel.

In excel I need to enter a number into a1 (serial #), return to a2 the
Corresponding data from access table to a2 [Deal Name] and from access to a3
[form #].

Should i use =vlookup(a1,'access table',?) or what?

If this makes no sense let me know and I will try again. Trying to follow
the rules and make it short and sweet.

ANY help would be very appreciated.

By "access table" do you mean you want to return a result from an Access
database? This can be done; I just want to make sure this is what you
are trying to do.