One way ..

Source table as posted is assumed in Sheet2's A1:E7

In Sheet1,
Input the var1 value in A1, eg: b
In B1 across are listed the values for var2, viz.: 1,2,3
In A2 down are listed the col headers: Qty, Size, Type

Put in B2, array-enter (press CTRL+SHIFT+ENTER to confirm the formula):
=INDEX(OFFSET(Sheet2!$A$2:$A$7,,MATCH($A2,Sheet2!$ 1:$1,0)-1),MATCH(1,(Sheet2!$A$2:$A$7=$A$1)*(Sheet2!$B$2:$B $7=B$1),0))
Copy B2 across/fill down to D4 populate
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---
"chads_vstream" wrote:
I need to pull info from sheet 2 to a table to sheet

sheet1
b
1 2 3
Qty
Size
Type


sheet2
variable1 variable2 Qty Size Type
a 1 2 1 trc
a 2 4 1.5 cb
a 3 3 4 cpb
b 1 5 0.5 ckb
b 2 3 0.75 cb
b 3 4 2 trc

I need the result to return the values for the qty, size, type
for variable 2
for variable 1

b <-(variable)
1 2 3
Qty (5) (3) (4)
Size (.5) (.75) (2)
Type (ckb) (cb) (trc)