<div>
that formula returns an error #N/A for some reason
</div>


that formula returns an error #N/A for some reason

<div>
Could you send a dummy ?<br />
<br />
What is the name of sheet 2?<br />
Do you want to compare abAdmin with admin like in your question?
</div>


Could you send a dummy ?

What is the name of sheet 2?
Do you want to compare abAdmin with admin like in your question?

<div>
<div class="content wysiwyg-content">
I have a xlsx with 2 sheets. In column E of sheet 1 I have created a blank column called &quot;user name&quot;. What I need is a formula whereby it checks the value in column D in sheet 1, to see if there is a value the same anywhere in sheet 2 column A, and if there is, populate sheet 2 column E with the value of sheet 2 column B (the same row)..<br />
<br />
So if sheet 1 cell D2 was &quot;abAdmin&quot;, and somewhere within column A in sheet 2 was admin, e.g. cell A52, then populate column E of sheet 1 with the value of B on the same row as the match. There will only be one possible match per sheet as each user is unique.
</div>
</div>


I have a xlsx with 2 sheets. In column E of sheet 1 I have created a blank column called "user name". What I need is a formula whereby it checks the value in column D in sheet 1, to see if there is a value the same anywhere in sheet 2 column A, and if there is, populate sheet 2 column E with the value of sheet 2 column B (the same row)..

So if sheet 1 cell D2 was "abAdmin", and somewhere within column A in sheet 2 was admin, e.g. cell A52, then populate column E of sheet 1 with the value of B on the same row as the match. There will only be one possible match per sheet as each user is unique.

excel formula for match and populate a cell

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

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

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.