Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Finding and Referencing between sheets

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Finding and Referencing between sheets

Resolved · High Priority · Version 2007

Reply Tue 21 Jul 2009, 11:57Delegate Chris said...

Chris has attended:
No courses

Finding and Referencing between sheets

Hi, I need to figure out how to find a value in a sheet and reference values from the row that value is in onto another sheet.
I'm trying to make an automated invoice sheet where all the info about the sale is put into the first sheet as a log and on the second sheet you need to fill out the item number feild and the rest of it will be automatically filled in by referencing info from the first sheet.

Basically each feild that needs to be automatically filled in on sheet 2 searches the A coloum from sheet 1 for the Item # (that has to be manually put into sheet 2) and references information from that row.

I know what i mean, but just incase ive confused anyone with my bad explaination of what im after, i made a quick excel book that will make it easier to understand (hopefully)
http://coronac.zoomshare.com/files/Referencing_between_sheets.xlsx

Thanks,
Chris

For upcoming training course dates see: Pricing & availability

Reply Tue 21 Jul 2009, 16:11Trainer Amanda said...

RE: Finding and Referencing between sheets

Hello Chris

Thank you for your question.

This requires using a VLOOKUP function. I've attached your example with the formulas in it, so you enter your item number on the invoice sheet and it pulls through the corresponding details from the Info sheet.

Kind regards
Amanda

Attached files...

vlookupinvoice.xls

Tue 28 Jul 2009: Automatically marked as resolved.

Excel articles

· Find Out How To Create That Missing Link With Excel
· Excel Offers A More Relaxing Way To Work Out
· How To Use The Research Functionality In Excel 2010
· Flexible uses for Excel at Home
· How To Create A Custom List In Excel

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips