1st nonblank after vlookup

pgeorgieff

New Member
Joined
Feb 20, 2019
Messages
2
Hi guys,

I have a two-sheet workbook. In the first sheet I have a list of companies (A), and revenue (B). I want to add a third column and to look for the number of cards the company bought for the first time (second sheet). In the second sheet we have (A) companies, (B to AA), number of cards against each company. Columns B to AA are months and years.
So let say one company has started working on January = column B, February = Column C, etc, before the starting month all cells are blank (not exactly since they are vlookuped from another sheet but without a value).
How could I find the first non-blank and its value after vlookuping the company?

I hope I am clear enough.
Thanks in advance,
Philip
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,108,509
Messages
5,523,313
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top