Autofill across worksheets
 

I maintain a list of custom items that are in production. Each item has
a sku and an associated description. I am looking for a way to autofill
the description when typing in the sku. My thought is to link two
worksheets together where one of them would contain a master list of
all sku's and their descriptions. This master list is being exported
from another application. Currently the sku and description are in
separate columns. Also, if there is an alternate way of doing this
please let me know. Thanks.


--
Apel
------------------------------------------------------------------------
Apel's Profile: http://www.excelforum.com/member.php...o&userid=34992
View this thread: http://www.excelforum.com/showthread...hreadid=547310

Autofill across worksheets
 

Typing in your SKUs in sheet1 cell A1, and working with sheet2 having your
master list and with your SKUs in column A and your descriptions in column B.
Type in the following into the cell where you want the desciption returned:
=VLOOKUP(A1,Sheet2!A1:B10,2,0)

Regards,
Tom
"Apel" wrote:


I maintain a list of custom items that are in production. Each item has
a sku and an associated description. I am looking for a way to autofill
the description when typing in the sku. My thought is to link two
worksheets together where one of them would contain a master list of
all sku's and their descriptions. This master list is being exported
from another application. Currently the sku and description are in
separate columns. Also, if there is an alternate way of doing this
please let me know. Thanks.


--
Apel
------------------------------------------------------------------------
Apel's Profile: http://www.excelforum.com/member.php...o&userid=34992
View this thread: http://www.excelforum.com/showthread...hreadid=547310

Autofill across worksheets
 

Works like a charm. Thanks. Is there a way for Excel to display an blank
cell instead of the #N/A when it cannot find a match?


--
Apel
------------------------------------------------------------------------
Apel's Profile: http://www.excelforum.com/member.php...o&userid=34992
View this thread: http://www.excelforum.com/showthread...hreadid=547310

Autofill across worksheets
 

=if(iserror(yourformula),"",yourformula)



Apel wrote:

Works like a charm. Thanks. Is there a way for Excel to display an blank
cell instead of the #N/A when it cannot find a match?

--
Apel
------------------------------------------------------------------------
Apel's Profile: http://www.excelforum.com/member.php...o&userid=34992
View this thread: http://www.excelforum.com/showthread...hreadid=547310

--

Dave Peterson

Autofill across worksheets
 

Apel

Similar to this.

Adjust the cell references to suit.

=IF(ISNA(VLOOKUP(F1,range,3,FALSE)),"",VLOOKUP(F1, range,3,FALSE))


Gord Dibben MS Excel MVP

On Thu, 1 Jun 2006 13:44:02 -0500, Apel
wrote:


Works like a charm. Thanks. Is there a way for Excel to display an blank
cell instead of the #N/A when it cannot find a match?