Columns into 2 way tables
Hi Christian,
One way, a bit involved, but works ok:
Output table in colums F, G, H
In F1, enter: Low
In G1, enter: Mid
In H1, enter: High
In F2, enter: =VLOOKUP(F$1,$A$2:$B$8,2,0)
Fill across to H1
In F3, enter:
=VLOOKUP(F$1,INDIRECT("A"&2+(MATCH(F2,$B$2:$B$9,0) )&":$C$10"),2,0)
Fill across to H3
Select F3:H3
Fill down until all columns are displaying #N/A
You can trap for the #N/A with an IF statement if you like.
Regards - Dave.
|