Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
Autofill Worksheets | Excel Discussion (Misc queries) | |||
can you autofill 12 worksheets each with the name of relevant mon. | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |