vlookup and hlookup formula, a good challenge
Assume your table A1:F7
=INDEX(A1:F7,MATCH(1,(A1:A7="Rose")*(B1:B7=15%),0) ,MATCH(2,A1:F1,0))
ctrl+shift+enter, not just 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
|