Using VLOOKUP funtion Within IF statement

Hi All,

I am trying to get the result by putting the if and voolkup together but not able to do it. Here i am attaching the file. Please have a look and suggest me how to do it or please do guide if you have any better way to do this.

In DATA sheet, i have 3 drop down, and will select the required data, when all the 3 condition matches it will go to reliance sheet and fetct the result and display it in A2. But here i am not getting which will be the vlookup value. I am not getting how to go ahead..

please help
thank you

Please someone help me

Member 1 means it can be 1Adult of 1 Child. So i have taken 2 Compinations like this. Because there are different values for both which i need to fetch and display. Yes, Sum Assured means 2 Lakh 3 Lakh tables. I dont know how to form a table.

If all the drop down values matches the the result ahould be displayed.

Please suggest me how to do this

Hello,

What i am trying to do is,

When all the drop down selected values matches then the result should be displayed for that age group in the reliance table. Here, member-1 means it can be either 1A or 1C, so i have taken both the combination. but i am not getting exactly how do i make the table.

Hey here am modified my sheet and still not able to get the result.

Please look into my sheet and help me

Thank you very much Haseeb. But now there is a bit different format in only one sheet. for that i am not getting how to do that.

And if the condition not satidfied how to display NOT APPLICABLE messahge .. please suggest. I tried to use ISEERROR. But couldnt do. here i ma attaching the sheet.
Please help

Thank you very much FDibbins.

Thanks vlady.

But i have another problem. I have mentioned in the file. In the sheet 'reliance', MEMBER column all the combination of a member(ex: if its Member 3, then all combinations like 1A+1C, 2A+1C, 3A, 2A+2C and 3C ) have values , but in the sheet 'bajaj' it doesn't has value for all the combination (for ex: if its 3A, i have value for only 2A+2C and 1A+2C). In this case how to put the formula which should be common for both the sheet.

please suggest

Hey Plz help me ... I just not able to do that.