VLOOKUP Between Separate Workbooks and Worksheets in Excel

http://www.TeachMsOffice.com
This will teach and show you how to use the vlookup function between separate worksheets and workbooks in excel.

You will learn how to use the vlookup to search through lists in closed workbooks and in separate excel files.

To follow along with the excel spreadsheet seen here and to find more excel stuff including free macros, keyboard shortcuts, and a forum, go to:

http://www.TeachMsOffice.com

Category:

Education

Tags:

• vlookup
• separate
• worksheets
• excel
• how
• to
• workbooks
• spreadsheets
• files
• closed
• linking
• lookup
• between
• teachexcel

[rbrunskill]

can anyone please help me.

I have a quoting excel engine that works out insurance quotes, i then save these quotes under new names and file them in one "quotes" file. The quotes file is situated in the same file as the quotesheet.

Can i create a completely seperate spreadsheet that will collate info from all these files and list in a borderaux type fashion, sorry if i made this sound complicated.

thanks in advance

[ExcelisHell]

@rbrunskill Send me a private message on here and I can help you.

[TheDarkemotion21]

can someone please help

Can you amend data using Vlookup???

Example imagine you entered the employee number and wanted to change the name. could you set it up so it would update in the main records?

many thanks

[ExcelisHell]

@TheDarkemotion21 yes but only with a macro. Contact me if you need more help with this.

[MsHrishi123]

THANKS A LOT



[xcrimsondragonx]

@wandilly go to view and then switch windows :)

[cisf0rcalvin]

thank you...works perfectly, saved me a lot of hassle!

[ThomasLa36]

What is the later tutorial you refer to at the 4:45 mark to pull the last name or first name from a cell containing both the first name and last name using vlookup?

[monasalem123]

Very helpful. Thanks

[wandilly]

Thanks for posting this valuable information , but I am not able to execute i my computer because the EXCEL toolbar does not have the option WINDOW, only the other values(Home, Insert, Page Layout, Formulas, Data, Review, View)

could you please help me on how can I add "window" that EXCEL toolbar?

(I tried to google but could not get it done...)

[arfraser12]

Thanks for the help.