Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup field and copy the row across
Hi, I am new to this so please be gentle:-) Can someone help me, I am trying to look for a value in one column in one sheet and when the value is found to copy that row into another sheet Is this something you can do with Excel? Many thanks in advance Ady -- adyden ------------------------------------------------------------------------ adyden's Profile: http://www.excelforum.com/member.php...o&userid=35407 View this thread: http://www.excelforum.com/showthread...hreadid=551792 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup field and copy the row across
This is easily accomplished by using either Vlookup or an Index and Match
combination, depending on where the values to return are located in relation to the lookup data. If all return values are to the right of the lookup value, Vlookup() can be used. Index and Match can be used wherever the return data is in relation to the lookup data. Check out the Help files for these functions, and if you need any help, post back with some specifics on how your data list is configured. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "adyden" wrote in message ... Hi, I am new to this so please be gentle:-) Can someone help me, I am trying to look for a value in one column in one sheet and when the value is found to copy that row into another sheet Is this something you can do with Excel? Many thanks in advance Ady -- adyden ------------------------------------------------------------------------ adyden's Profile: http://www.excelforum.com/member.php...o&userid=35407 View this thread: http://www.excelforum.com/showthread...hreadid=551792 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup field and copy the row across
Many thanks - I will have a look -- adyden ------------------------------------------------------------------------ adyden's Profile: http://www.excelforum.com/member.php...o&userid=35407 View this thread: http://www.excelforum.com/showthread...hreadid=551792 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup field and copy the row across
OK I am getting closer:-) I have a spreadsheet with a number of columns, these have details susch as serial numbers, part numbers and status In the status column I am looking to take any rows with a certain status and put them in another tab The formula I have =MATCH("Degaused",Sheet1!I:I,0) is showing the number of occourances, so it is picking the info but not displaying it as the complete row:-( Hope this makes sense? -- adyden ------------------------------------------------------------------------ adyden's Profile: http://www.excelforum.com/member.php...o&userid=35407 View this thread: http://www.excelforum.com/showthread...hreadid=551792 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
How to Copy Data from on field to another? Complex? | Excel Discussion (Misc queries) | |||
How to copy Memo BLOB field from Interbase database | Excel Discussion (Misc queries) | |||
can i copy a tab name into a field | Excel Worksheet Functions | |||
F7 in zip field when doing mail merge from excell file | Excel Discussion (Misc queries) |