Forum Discussion
Excel formula with if and vlookup ?
First of hello Community! I am using : Microsoft® Excel® for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20272) 64-bit I need VLOOKUP and IF formula with more conditions, maybe even som...
This is working, but still not 100% to what i need:
So, I receive list of ID. Then i need to copy ID into Mappe 33 for check up, but formula returns only 3 values, that are set in G1, H1 and I1. How do I overcome this "limit" (G1, H1 and I1) if i have 338+ groups ("Characteristic") ?
The maximum number of characters (digits) in a cell in Excel is 32767. One formula has already about 450 characters (digits). Therefore it shouldn't be possible to combine more than roughly 70 formulas with " & " into one comprehensive formula.
If you have 338 characteristic from column E you can use 5 result columns (instead of only column B) with one formula each. Each formula then checks for roughly 70 characteristic.
For one comprehensive formula you can then dynamically enter the characterisitc from column E in e.g. range G1:BX1 (70 cells with 70 characteristic). Of course you can as well enter the criteria for example in range G1:P7 which i would prefer. For the next comprehensive formula you can then enter the criteria in range G8:P14 and so on.
thank you very much for you time and instructions.
This will be a great improvement for me.