richard1234567891011
Board Regular
- Joined
- Feb 21, 2018
- Messages
- 91
Hello guys, I have an issue with the Vlookup formula. Pratically I need the formula To search the value corresponding to the names. I have a formula like that =Vlookup(J3;I14:J52;2;0) and it is fine it is working. The problem is that formula is working for the "quota fissa" column. In order to make it works also for the "quota variable" column i had to insert again all the number of component row. with this formula =vlookup(J3;K14:L52;2;0). So my question is: How can I set the second formula in order to remove the number second "number of components row and make it works? I want put the "quota variable" column near to "quota fissa" column but in order to do that I need a Vlookup formula that is able to read 2 areas, because in the middle (for the second formula) there is the "quota fissa" row.
Thank you guys.
Thank you guys.