Vlookup from Access

  • Thread starter Thread starter MitzDriver
  • Start date Start date
M

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.
 
Thank you for replying.

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



smartin said:
MitzDriver said:
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.
Click to expand...

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.
Click to expand...
 
Back
Top