table data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I have three columns of data which I would like to get into a table.
I cant use a pivot table as each column is alpha none are numeric What I am
after is some kind of look up function that would look up both the column
heading in column 1 and row title in column 2 and then return the data in
column 3

Something like below....

Has any body got any ideas?

Thanks

Raw......
Column Row Data
Budget1 Code1 unique1
Budget1 Code2 unique2
Budget1 Code3 unique3
Budget2 Code1 unique4
Budget2 Code2 unique5
Budget2 Code3 unique6
Budget3 Code1 unique7
Budget3 Code2 unique8
Budget3 Code3 unique9

Table......
Budget1 Budget2 Budget3
Code1 unique1 unique4 unique7
Code2 unique2 unique5 unique8
Code3 unique3 unique6 unique9
 
With raw data in A2 to C10 and new table starting row 14, enter this with
Ctrl+Shift+Enter and copy across and down


=INDEX($C$2:$C$10,MATCH(B$13 & $A14,$A$2:$A$10&$B$2:$B$10,0))

Change B13 and A14 to suit

A B C D
Budget1 Budget2 Budget3 <==== row 13
Code1 unique1 unique4 unique7
Code2 unique2 unique5 unique8
Code3 unique3 unique6 unique9

HTH
 
Back
Top