View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Solar Man[_2_] Solar Man[_2_] is offline
external usenet poster
 
Posts: 7
Default Multiple criteria

Sheet 2 L6 has the amount of solar radiation per solar panel in that state
and at that angle. The idea is to pick the angle and the state and that will
determine the amount of solar radiation I will get per panel. (L 6 ) At a
different angle the solar radiation will be different, or in a different
state.

I had to leave for the afternoon and I will get back to the problem tomorrow
afternoon. Again, thank you for your help.

"T. Valko" wrote:

=VLOOKUP(Sheet1!G4,Sheet2!P37:Y38,MATCH(Sheet1!E19 ,Sheet2!P37:Y37,0),Sheet2!L6)


What's in Sheet2!L6?

If you want an *exact* match of the angle that 4th argument must be either 0
or FALSE. If you want an "approximate" match then the 4th argument must be
either 1 or omitted *and* the angles must be listed in ascending order.

--
Biff
Microsoft Excel MVP