vlookup

[trailblazertbs]

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]

- 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]

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