View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default vlookup and hlookup formula, a good challenge

If your table is in A1:F7

A11=Rose
B11=15%
C11=2

you could try
=MAX((A2:A7=A11)*(B2:B7=B11)*(C1:F1=C11)*C2:F7)

array entered. After typing in the formula hold Control+Shift keys and hit
enter.


"Frances C" wrote:

to beginu thanks for your help. I need a formula for the following
information. I have a table with the following information:
1 2 3 4
Rose 5% 101 102 103 104
Rose 10% 201 202 203 204
Rose 15% 301 302 303 304
Jack 3% 401 402 403 404
Jack 6% 501 502 503 504
Jack 9% 601 602 603 604

I need a formula that when I request "Rose @ 15% @ 2" My answer is 302

Hope you can understand, Thanks

Frances