Excel Formula

[hrayani]

Hi,

I need an excel formula to show a list if cells in column C is blank..

Kindly have a look below. Formula required starting from cell A14

Mr Excel Query.xlsx
	A	B	C
1	Sample DATA
2	PO #	Target Date	Actual Date
3	510	1-Jan
4	509	1-Jan	5-Jan
5	501	1-Jan
6	825	2-Jan
7	511	5-Jan
8	512	5-Jan
9	498	6-Jan	4-Jan
10	123	3-Jan
11
12	Pending List
13	PO #	Target Date	Actual Date
14	510	1-Jan
15	501	1-Jan
16	825	2-Jan
17	511	5-Jan
18	512	5-Jan
19	123	3-Jan
Sheet1

Cell Formulas
Range	Formula
B14:B19	B14	=VLOOKUP(A14,$A$2:$C$10,2,FALSE)

Any help would be appreciated

Regards,

Humayun

 

[Fluff]

yes, I suspect so, but don't know how.

 

[hrayani]

yes, I suspect so, but don't know how.

Thanks anyways Fluff for you help & support

 

[Fluff]

You're welcome & thanks for the feedback.