Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transferring data from column to another without VLOOKUP
Ok, so this is going to be a bit difficult to explain, AND I'm a newbie to
functions. I've got one spreadsheet with an array of data that looks like this. spreadsheet A CL 45,000 CH 300 DE 8,884 As you can guess, the letters are in one column and the numbers in another. spreadsheet B BB 0 BZ 0 CL 0 CM 0 CN 0 DA 0 DE 0 So what I would like to do is copy the info from spreadsheet A to spreadsheet B. I know that VLOOKUP can do this for me but generates an error in spreadsheet B for every letter code that isn't in spreadsheet A. I'm trying to avoid this and have the number values appear for letter codes in spreadsheet B that are in spreadsheet A and a 0 for letter codes that aren't in spreadsheet A. Can anybody help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with transferring data in one column to multiple columns. | New Users to Excel | |||
transferring amount to particular month column | Excel Worksheet Functions | |||
how to setup transferring data from row to column | Setting up and Configuration of Excel | |||
How to setup transferring data from row to column? | Excel Discussion (Misc queries) | |||
vlookup...transferring info from 1 sheet to another.... | Excel Worksheet Functions |