Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

finding and referencing between

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

Finding and Referencing between sheets

ResolvedVersion 2007

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

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 tip:

Excel 2010 Shortcuts - Start and End of the Worksheet

Did you know you can quickly move to either the beginning or the end of an Excel Worksheet using just a couple of keys on the keyboard?

Press Ctrl + Home key to move the cursor to cell A1

Press Ctrl + End key to move the cursor to the end of the current worksheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.