EE-29069958-Version1.xlsx

<div>
any further assistance is needed here?
</div>


<div>
Hi dstewart,<br />
<br />
Is there anything that doesn't work in the above solution?<br />
<br />
Thanks,<br />
<br />
Alan.
</div>


Hi dstewart,

Is there anything that doesn't work in the above solution?

Thanks,

Alan.

<div>
<div class="content wysiwyg-content">
I have an excel spread sheet with 3 columns; [a,b,c] with thousands of rows that line up in the a,b column. What I need is to search column b for the value in column c, and if it matches, take the value from column a and put it NEXT too column C.<br />
<br />
The alternative would be to have column c get sorted into where it matches column b. with all the blank spaces at the bottom of the list. I only care about the values of column a when b and c match. Column c also has blank spaces and will only match with ~30% of column b.<br />
<br />
Please help :(
</div>
</div>


I have an excel spread sheet with 3 columns; [a,b,c] with thousands of rows that line up in the a,b column. What I need is to search column b for the value in column c, and if it matches, take the value from column a and put it NEXT too column C.

The alternative would be to have column c get sorted into where it matches column b. with all the blank spaces at the bottom of the list. I only care about the values of column a when b and c match. Column c also has blank spaces and will only match with ~30% of column b.

Please help :(

Comparing 3 columns and outputting to 4th column if 2 values match

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.