| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching data from one worksheet to another.
Hello,
I have a 2 worksheets.. one has in it a list of asset numbers The other has all the asset numbers, descriptions etc of the assets. I want to be able to have a formula in colunm B that looks up the asset number in colunm A but in the other worksheet, and then reports on what the description is. I thought this would work but it didnt.. =lookup(A2,OVSDDUMP!A:B) I was hoping that would look up the A2 asset number and the A colunm of the OVSDDUMP sheet and report back what is in the B colunm of that row. Any help here would be appriciated. Regards, Jeffrey |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Matching data from one worksheet to another.
Dear Jeffa,
try this: =Vlookup(A2,OVSDDUMP!A:B,2,false) HTH "Jeffa" wrote: Hello, I have a 2 worksheets.. one has in it a list of asset numbers The other has all the asset numbers, descriptions etc of the assets. I want to be able to have a formula in colunm B that looks up the asset number in colunm A but in the other worksheet, and then reports on what the description is. I thought this would work but it didnt.. =lookup(A2,OVSDDUMP!A:B) I was hoping that would look up the A2 asset number and the A colunm of the OVSDDUMP sheet and report back what is in the B colunm of that row. Any help here would be appriciated. Regards, Jeffrey |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Matching data from one worksheet to another.
Thanks, worked a treat, I knew it would be something simple like that, but
the help files don't give me enough of an example :( " wrote: Dear Jeffa, try this: =Vlookup(A2,OVSDDUMP!A:B,2,false) HTH "Jeffa" wrote: Hello, I have a 2 worksheets.. one has in it a list of asset numbers The other has all the asset numbers, descriptions etc of the assets. I want to be able to have a formula in colunm B that looks up the asset number in colunm A but in the other worksheet, and then reports on what the description is. I thought this would work but it didnt.. =lookup(A2,OVSDDUMP!A:B) I was hoping that would look up the A2 asset number and the A colunm of the OVSDDUMP sheet and report back what is in the B colunm of that row. Any help here would be appriciated. Regards, Jeffrey |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Matching data from one worksheet to another.
Dear Jeffrey,
Glad I can help. Remember! Vlookup syntax is divided into 4 parts. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
| Alphabetical Code and matching data to a new worksheet | Excel Discussion (Misc queries) | |||
| Find matching data in two worksheet columns | Excel Worksheet Functions | |||
| Retreiving font when matching data from one worksheet to another | Excel Discussion (Misc queries) | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Linear Mode
