View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MitzDriver MitzDriver is offline
external usenet poster
 
Posts: 10
Default Vlookup from Access

Thank you for replying.

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



"smartin" wrote:

MitzDriver wrote:
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.