# If Statment Help

#### Huizar

##### Board Regular
 Number Fill Address 1026 902 E. Fremont 902 E. Fremont 1063 871 Main Street 829 Main

<tbody>
</tbody>
1263

Hello All, I need help. I'm looking for statement that will help me fill the middle Column. For Example, If the address ha a row number then fill it with the number column number with the number assuming the address Is identical. If No number for the address, then leave it blank. I put a table as an example.

Thank you!!

#### Eric W

##### MrExcel MVP
Is this what you want?

#### Huizar

##### Board Regular
Hey Eric,

Thanks for the response. Did you see the address match? Then can the formula bring down 1026? so in Other words row 2 and 3 should have 1026.

Thanks!!

#### Eric W

##### MrExcel MVP
OK, try this:

B2: =IF(AND(C2=C1,A2=""),B1,IF(A2="","",IF(ISNUMBER(LEFT(C2)+1),A2 &MID(C2,FIND(" ",C2&" "),99),"")))

Last edited:

#### Scott Huish

##### MrExcel MVP
Perhaps:
=IF(AND(A2<>"",C2<>""),A2&" "&REPLACE(C2,1,FIND(" ",C2),""),IF(C2=C1,B1,""))

Thanks Eric!

#### Huizar

##### Board Regular
Hey Scott, is there a way a just to bring in the Number in Cell B (i.e. only 1026).

Thanks!

Like this?

Thank you Scott!

1,082,130
Messages
5,363,333
Members
400,726
Latest member

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...