| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read Matrix via function
Hi,
I have a matrix as follow Name/Grade Dan Ben Dave Laura Math A A+ C A English B A B A+ How can I have a VBA fuction that will read this matrix, for example Name_Grade( Ben , English ) = "A" Name_Grade( Dave , Math ) = "C" Many thanks, Dan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Read Matrix via function
Dan,
A formula is much simpler =INDEX(A1:E20, MATCH(F1,A1:A20,0), MATCH(G1,A1:E1,0)) Where F1 is the subject and G1 is the name to lookup Mike "Dan" wrote: Hi, I have a matrix as follow Name/Grade Dan Ben Dave Laura Math A A+ C A English B A B A+ How can I have a VBA fuction that will read this matrix, for example Name_Grade( Ben , English ) = "A" Name_Grade( Dave , Math ) = "C" Many thanks, Dan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Read Matrix via function
Great formula! Does it work on Pivot tables- when the lookup value is in a
different sheet ? Does it require Ctrl+Enter? Thanks (sorry to interrupt) "Mike H" wrote: Dan, A formula is much simpler =INDEX(A1:E20, MATCH(F1,A1:A20,0), MATCH(G1,A1:E1,0)) Where F1 is the subject and G1 is the name to lookup Mike "Dan" wrote: Hi, I have a matrix as follow Name/Grade Dan Ben Dave Laura Math A A+ C A English B A B A+ How can I have a VBA fuction that will read this matrix, for example Name_Grade( Ben , English ) = "A" Name_Grade( Dave , Math ) = "C" Many thanks, Dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Funtion as Matrix function? | Excel Programming | |||
| read Matrix | Excel Programming | |||
| Can I write a function like matrix function? | Excel Programming | |||
| UDF function on Matrix | Excel Programming | |||
| VBA function return matrix? | Excel Programming | |||
Linear Mode
