software

Hello

Can anyone help please?

I need to look up an estimate number which is workbook number 1 and find it
in work book number 2 and then find the selling price value and enter it in a
blank cell in work book number 1.

I thought this would work with a vlookup but I only get some correct results
and then the ones it can not locate it puts in the last value that is found
in workbook 2.

How do I get the spreadsheet to give me only the correct answers and where
the estimate number can not be found leave it blank or but n/a?

The estimate numbers are combinations of letters and numbers e.g. I45236.
Could this be causing the problem?
--
Thanks for your advice in advance.
Excel Crazy

Use False as the fourth parameter of the VLOOKUP function to force an exact match. To prevent the
NA from appearing, use

=IF(ISERROR(VLOOKUP(....)),quot;quot;,VLOOKUP(....))

HTH,
Bernie
MS Excel MVPquot;Excelcrazyquot; gt; wrote in message
...
gt; Hello
gt;
gt; Can anyone help please?
gt;
gt; I need to look up an estimate number which is workbook number 1 and find it
gt; in work book number 2 and then find the selling price value and enter it in a
gt; blank cell in work book number 1.
gt;
gt; I thought this would work with a vlookup but I only get some correct results
gt; and then the ones it can not locate it puts in the last value that is found
gt; in workbook 2.
gt;
gt; How do I get the spreadsheet to give me only the correct answers and where
gt; the estimate number can not be found leave it blank or but n/a?
gt;
gt; The estimate numbers are combinations of letters and numbers e.g. I45236.
gt; Could this be causing the problem?
gt; --
gt; Thanks for your advice in advance.
gt; Excel Crazy
Thanks

I tried this but it did not work. With false added as the fourth parameter
it brought back no answer for any row. With the fourth parameter left out I
get the correct answer where an exact match of the estimate number can be
located, but where the estimate number could not be found it puts in a figure
from the closest estimate number that it can find.

I need the ones that can not be located to be left either as blank cells or
state n/a .

Where am I going wrong?
--
Thanks for your advice in advance.
Excel Crazyquot;Bernie Deitrickquot; wrote:

gt; Use False as the fourth parameter of the VLOOKUP function to force an exact match. To prevent the
gt; NA from appearing, use
gt;
gt; =IF(ISERROR(VLOOKUP(....)),quot;quot;,VLOOKUP(....))
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;Excelcrazyquot; gt; wrote in message
gt; ...
gt; gt; Hello
gt; gt;
gt; gt; Can anyone help please?
gt; gt;
gt; gt; I need to look up an estimate number which is workbook number 1 and find it
gt; gt; in work book number 2 and then find the selling price value and enter it in a
gt; gt; blank cell in work book number 1.
gt; gt;
gt; gt; I thought this would work with a vlookup but I only get some correct results
gt; gt; and then the ones it can not locate it puts in the last value that is found
gt; gt; in workbook 2.
gt; gt;
gt; gt; How do I get the spreadsheet to give me only the correct answers and where
gt; gt; the estimate number can not be found leave it blank or but n/a?
gt; gt;
gt; gt; The estimate numbers are combinations of letters and numbers e.g. I45236.
gt; gt; Could this be causing the problem?
gt; gt; --
gt; gt; Thanks for your advice in advance.
gt; gt; Excel Crazy
gt;
gt;
gt;

You could be going wrong due to formatting - Excel may show whole numbers when they are entered with
one decimal, and you may think are that you have an exact match but you don't really.

Post an example of your data table, and the formula that you are using, and we'll figure it out....

HTH,
Bernie
MS Excel MVPquot;Excelcrazyquot; gt; wrote in message
...
gt; Thanks
gt;
gt; I tried this but it did not work. With false added as the fourth parameter
gt; it brought back no answer for any row. With the fourth parameter left out I
gt; get the correct answer where an exact match of the estimate number can be
gt; located, but where the estimate number could not be found it puts in a figure
gt; from the closest estimate number that it can find.
gt;
gt; I need the ones that can not be located to be left either as blank cells or
gt; state n/a .
gt;
gt; Where am I going wrong?
gt; --
gt; Thanks for your advice in advance.
gt; Excel Crazy
gt;
gt;
gt; quot;Bernie Deitrickquot; wrote:
gt;
gt;gt; Use False as the fourth parameter of the VLOOKUP function to force an exact match. To prevent
gt;gt; the
gt;gt; NA from appearing, use
gt;gt;
gt;gt; =IF(ISERROR(VLOOKUP(....)),quot;quot;,VLOOKUP(....))
gt;gt;
gt;gt; HTH,
gt;gt; Bernie
gt;gt; MS Excel MVP
gt;gt;
gt;gt;
gt;gt; quot;Excelcrazyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hello
gt;gt; gt;
gt;gt; gt; Can anyone help please?
gt;gt; gt;
gt;gt; gt; I need to look up an estimate number which is workbook number 1 and find it
gt;gt; gt; in work book number 2 and then find the selling price value and enter it in a
gt;gt; gt; blank cell in work book number 1.
gt;gt; gt;
gt;gt; gt; I thought this would work with a vlookup but I only get some correct results
gt;gt; gt; and then the ones it can not locate it puts in the last value that is found
gt;gt; gt; in workbook 2.
gt;gt; gt;
gt;gt; gt; How do I get the spreadsheet to give me only the correct answers and where
gt;gt; gt; the estimate number can not be found leave it blank or but n/a?
gt;gt; gt;
gt;gt; gt; The estimate numbers are combinations of letters and numbers e.g. I45236.
gt;gt; gt; Could this be causing the problem?
gt;gt; gt; --
gt;gt; gt; Thanks for your advice in advance.
gt;gt; gt; Excel Crazy
gt;gt;
gt;gt;
gt;gt;