Forum Discussion
IF Formula Help
Dear All
İ have two table as below Table A and Table B . İ would like create vlookup for Table B and see " Install Cost" but on Table B i only want to see " 20A" group's cost on table B .How can i create the formula for this issue could you pls help
thanks in advance
4 Replies
erhan_79 there are many ways to do it, I can give you the answer but provide a proper solution I need to know:
- Is this group value unique between in both the tables?
- Is this group value unique in Table B table if not in the both?
- What is the logic that you only need install cost for Product A.
As I said , there are many ways to resolve it but once I have the answer of above questions, I can provide your effective solution.
dear parry2k ;
i tried to explain your questions as below under your questions :
-Is this group value unique between in both the tables?
Yes
- Is this group value unique in Table B table if not in the both?
Yes it is unique too.
- What is the logic that you only need install cost for Product A.
İnfact i have a huge issue sure , just i needed to show a limited example ,you should imagine like that let me explain pls;
i have two tables ,and in these both table there are "Group" columns which has unique values.In "Table A " there is "Install Cost" column also but in "Table B" there is no "Install Cost" column.So i would like to create " Install Cost " column in "Table B" .But while creating i just want to see on these column's inside " 20A" 's (Group ) cost only.Other Group's (20B or 20C) value i dont want to see in table B new created "install cost" column
i hope it is clear
