Help with Vlookup

[bergmc00]

Hello all,

Perhaps this is a simple task but need your help. I am trying to determine the zero values in column 3 in a column of data that has over 500 data points and would like to pull the name of the company in column 1 that reflects a zero balance from column 3. The formula would be set in column 4. What would be the best way to approach doing this. Sorry for the novice question.

 

[doofusboy]

In cell D1 you could enter this formula:

=IF(C1=0,A1,"")

* copy down as far as needed

 

[T. Valko]

Hello all,

Perhaps this is a simple task but need your help. I am trying to determine the zero values in column 3 in a column of data that has over 500 data points and would like to pull the name of the company in column 1 that reflects a zero balance from column 3. The formula would be set in column 4. What would be the best way to approach doing this. Sorry for the novice question.

Is this what you mean...

Book1
	A	B
1	Name1	83
2	Name2	63
3	Name3	36
4	Name4	0
5	Name5	57
6	Name6	75
7	Name7	83
8	Name8	72
9	Name9	36
10	Name10	79
Sheet1

Formula to return Name4:

=INDEX(A1:A10,MATCH(0,B1:B10,0))

 

[bergmc00]

first explanation worked, thank you

 

[bergmc00]

Hi there,

quick followup, if I was to agree to columns to each other in a third column but the first column had some data that included some letters included along with the number I need identified, how would I set up that formula. For example, two columns listed below:

<TABLE style="WIDTH: 381pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=508 border=0><COLGROUP><COL style="WIDTH: 333pt; mso-width-source: userset; mso-width-alt: 16237" width=444><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD id=td_post_2719319 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 333pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=444 height=20> G_4397.</TD><TD class=xl94 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dbe5f1" width=64>4397</TD></TR></TBODY></TABLE>