<div>
You might use a formula like:<br />
=IFERROR(VLOOKUPD2,'Other sheet'!$A$2:$B$1000,2,FALS<wbr />E),&quot;&quot;)
</div>


You might use a formula like:
=IFERROR(VLOOKUPD2,'Other sheet'!$A$2:$B$1000,2,FALSE),"")

<div>
Great response, exactly what I was trying to figure out. Sorry to the other reply which I like as it gets rid of errors but I cannot get it to run.
</div>


Great response, exactly what I was trying to figure out. Sorry to the other reply which I like as it gets rid of errors but I cannot get it to run.

<div>
Brad's was just missing a parenthesis:<br />
<br />
=IFERROR(VLOOKUP<b>(</b>D2,'Other sheet'!$A$2:$B$1000,2,FALS<wbr />E),&quot;&quot;)
</div>


Brad's was just missing a parenthesis:

=IFERROR(VLOOKUP(D2,'Other sheet'!$A$2:$B$1000,2,FALSE),"")

<div>
Thanks Rory. That's what I get for not testing.<br />
<br />
Brad
</div>


Thanks Rory. That's what I get for not testing.

Brad

<div>
Hi Brad,<br />
I cannot change the points but big thanks anyway. <br />
Actually the &nbsp;formula should be:<br />
=IFERROR(VLOOKUP(A1,'Other<wbr /> sheet'!$A$2:$B$1000,2,FALS<wbr />E),&quot;&quot;)<br />
I have tested and it works perfectly.<br />
<br />
Thanks<br />
Dave
</div>


Hi Brad,
I cannot change the points but big thanks anyway.
Actually the  formula should be:
=IFERROR(VLOOKUP(A1,'Other sheet'!$A$2:$B$1000,2,FALSE),"")
I have tested and it works perfectly.

Thanks
Dave

<div>
<div class="content wysiwyg-content">
I have a sheet that contains project numbers (column A) and descriptions in column B.<br />
In another sheet I have created a dropdown box that has all the project numbers. I want the adjacent column to fill in the description depending on the project number selected.
</div>
</div>


I have a sheet that contains project numbers (column A) and descriptions in column B.
In another sheet I have created a dropdown box that has all the project numbers. I want the adjacent column to fill in the description depending on the project number selected.

Cell look up

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