VLOOKUP Between Separate Workbooks and Worksheets in Excel

[MsHrishi123]

THANKS A LOT

[cisf0rcalvin]

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

[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.

[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...)

[xcrimsondragonx]

@wandilly go to view and then switch windows :)

[arfraser12]

Thanks for the help.

[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.

[manducerva]

Helpful also if I use MO 2007

[michaelscofield20587]

on the workbook i am working on, i need to type a vegetable into a selection reference box, press enter, so that it displays 3 different sets of inromation in 3 different fields below it. It gets the information from a second worksheet. I don't know how to do it :(

[HataOrange]

Very helpful!