View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Piet vd Berg Piet vd Berg is offline
external usenet poster
 
Posts: 1
Default Need an Excell function that can lookup vertical AND horizontal

I need a function or combination of functions that can first search say
vertical in the leftmost column and then horizontal on the top line and then
read a value in the table. It must thereforehave two input criterion.
In the example below it must first look up "Bruce" as input criteria 1, then
look up "Good" as input criteria 2 and then return "6" as the output.

Excellent Good Bad Very Bad
John 8 5 3 1
Peter 10 8 4 2
Bruce 7 6 2 1
Eric 9 8 6 3