ResearchV on merged cells
Solved
Emdii
Posted messages
10
Status
Membre
-
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
Hello,
Could you tell me if it is possible, and if so, how to perform a VLOOKUP on "merged cells"?
In my screenshot, with the formula, I wanted to see "Phase 1" appear in cell E2 using the VLOOKUP formula.
Thank you in advance for your help,
Best regards,
Emdii
Configuration: Windows / Chrome 48.0.2564.116
Could you tell me if it is possible, and if so, how to perform a VLOOKUP on "merged cells"?
In my screenshot, with the formula, I wanted to see "Phase 1" appear in cell E2 using the VLOOKUP formula.
Thank you in advance for your help,
Best regards,
Emdii
Configuration: Windows / Chrome 48.0.2564.116
2 réponses
Hello,
When you merge cells, actually only the first cell in the top left contains the text, the others are "empty". So they still exist but are empty and for this reason your formulas will return an empty value (or 0 in the case of a VLOOKUP).
One piece of advice: no merged cells when the data still needs to be processed :-)
Best of luck,
When you merge cells, actually only the first cell in the top left contains the text, the others are "empty". So they still exist but are empty and for this reason your formulas will return an empty value (or 0 in the case of a VLOOKUP).
One piece of advice: no merged cells when the data still needs to be processed :-)
Best of luck,
Hello,
it's not really a VLOOKUP() that you need.
Start your data 1 row lower and in E2:
=IF(B2="",E1,B2)
eric
--
By continually trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, yes, it happens!!!), remember to set it as resolved. Thank you.
it's not really a VLOOKUP() that you need.
Start your data 1 row lower and in E2:
=IF(B2="",E1,B2)
eric
--
By continually trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, yes, it happens!!!), remember to set it as resolved. Thank you.
This situation is extremely disappointing!!
You can't do anything about it, I express my great disappointment towards Microsoft for software that is supposed to be "cutting-edge" and expensive...