Lookup?

[Safecracker]

Hello all, I am not sure if lookup is the command I require or not, but the following is the challenge I am facing.

I use an excel form for quotations, and have an excel database of all my customers. What I am hoping to do is when I enter the customer number in the quote form, for excel to lookup up that customer number in the database and then populate the customer name, address etc in the quote form.

Can someone please point me in the right direction on how I could achieve this.

Thanks in advance!

[NBVC]

Have you taken a look at Vlookup in Excel help...I think that is what you need.

If you have further questions, please post back.

[Safecracker]

Hi NVBC, thanks for your reply. I have read the help for Vlookup, although what I think I really require is a macro.

I would like to enter my customer number, then execute the macro which would then lookup the customer number from another file, and populate the customers address and contact numbers.

Any ideas?

Thanks

[NBVC]

I'm not sure you really need a macro for that...

e.g. =Vlookup(A1,[otherdoc.xls]sheet1!A1:C100,2,FALSE)


would lookup the item in A1 of your activesheet in a Sheet1 of another workbook called otherdoc.xls within table that ranges from A1:C100 (column A holds the customer names to match and column B and C hold the information to return)... in this case items from the 2nd column (Column B) would be returned.

[Safecracker]

NBVC, thanks for your help, you are correct I did not need a macro to do what I wanted to, everything is working great!