vlookup

trailblazertbs · Mar 25th, 2002, 09:28 AM

I am trying to use a vlookup to look at four separate sheets at the same time in order to create a database where I copy and paste the information on another sheet in order to sort various ways to create charts. I want to be able to type the LOT NUMBER in and pull all the other information in. The operators will be entering this information in based on their respective machine. I will then enter the lot number at the end of the shift onto another worksheet. I hope this makes sense

LOT NUMBER DATE STYLE SHIFT UCL "UPPER
STANDARD" AVERAGE "SAMPLE
AVERAGE" "LOWER
STANDARD" LCL UCL RANGE AVERAGE LCL

Dave Patton · Mar 25th, 2002, 09:48 AM

- What formulas have you tested?

- What is the layout of your information?

- What result do you require?

=vlookup(a1,data1,2,0)+vlookup(a1,data2,2,0)+
vlookup(a1,data3,2,0)+vlookup(a1,data4,2,0)

The data1 etc are named ranges for your information on the 4 sheets.

Duane · Mar 25th, 2002, 12:28 PM

If you can, email a copy of your spreadsheet, and I'll take a look at it.

Mar 25th, 2002, 12:28 PM	#3
Duane Board Regular Join Date: Mar 2002 Location: Toronto Posts: 173	If you can, email a copy of your spreadsheet, and I'll take a look at it. __________________ Regards, Duane h. Office2003 in WinXP o. Office2007 in Win7

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 09:28 AM	#1
trailblazertbs New Member Join Date: Mar 2002 Posts: 1	I am trying to use a vlookup to look at four separate sheets at the same time in order to create a database where I copy and paste the information on another sheet in order to sort various ways to create charts. I want to be able to type the LOT NUMBER in and pull all the other information in. The operators will be entering this information in based on their respective machine. I will then enter the lot number at the end of the shift onto another worksheet. I hope this makes sense LOT NUMBER DATE STYLE SHIFT UCL "UPPER STANDARD" AVERAGE "SAMPLE AVERAGE" "LOWER STANDARD" LCL UCL RANGE AVERAGE LCL

Mar 25th, 2002, 09:48 AM	#2
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	- What formulas have you tested? - What is the layout of your information? - What result do you require? =vlookup(a1,data1,2,0)+vlookup(a1,data2,2,0)+ vlookup(a1,data3,2,0)+vlookup(a1,data4,2,0) The data1 etc are named ranges for your information on the 4 sheets.