Vllookup & Hlookup combination

[dxzaber]

https://drive.google.com/file/d/0B1GJKIl2o1WZNWtHWGItWURZLTg/view?usp=sharing

Please refer to to table AY6 To BM18 (Overall Pressure Coefficient ,Cp for X direction)

for value in cell AY11 & BI7 ,formula in BK21 should return value of 1.360098 .but instead it's giving BI7 ...WHY???

Notice their is a column(AA) hidden table

 

[Muhammad_Usman]

Try this one!

=INDEX(BI10:BI18,MATCH(AY11,AZ10:AZ18,0))

 

[Muhammad_Usman]

Check also this one!

=HLOOKUP(BI7,BB9:BL18,MATCH(AY11,AZ9:AZ18,0))

 

[dxzaber]

value in cell AY11 & BI7 will change .say for .5 in BI7 your formula does not work..

 

[dxzaber]

this one works. Thanks a Lot

Check also this one!

=HLOOKUP(BI7,BB9:BL18,MATCH(AY11,AZ9:AZ18,0))

 

[dxzaber]

But why Vloopup & Hlookup not working ????

 

[Muhammad_Usman]

Glad to help you!

this one works. Thanks a Lot

 

[Muhammad_Usman]

The first part of your formula(h lookup) is working but the second part v lookup not gives the row number in result which is reburied by h lookup that's why its not working

But why V Lookup & H lookup not working ????

 

[dxzaber]

Can you solve it using Vlookup & hlookup???

The first part of your formula(h lookup) is working but the second part v lookup not gives the row number in result which is reburied by h lookup that's why its not working

 

[Muhammad_Usman]

It seems difficult because v lookup doesn't return the row number as reference.
Why you didn't use the h lookup index function . Did it not sufficient for you??

 [COLOR=#333333][I]=HLOOKUP(BI7,BB9:BL18,MATCH(AY11,AZ9:AZ18,0))[/I][/COLOR]