Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup
Hello
i'm not sure which function i should use. column A has numbers from 5000 to 5999 column B i have put a "x" in the cell of the row i wish to populate the other worksheet column C last name column D first name and so on in the other worksheet i would like to populate only the row that have the "x" in the cell i would also like to populate only certain column of that row in that new spreadsheet thank you JY |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup
Apply Autofilter to column B and select x from the filter pull-down.
Then highlight the visible data (just the columns you want to take) and click <copy then <paste this into the new worksheet. Hope this helps. Pete On Nov 13, 9:40*am, jy wrote: Hello i'm not sure which function i should use. column A has numbers from 5000 to 5999 column B i have put a "x" in the cell of the row i wish to populate the other worksheet column C last name column D first name and so on in the other worksheet i would like to populate only the row that have the "x" in the cell i would also like to populate only certain column of that row in that new spreadsheet thank you JY |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup
Hi JY
Let's say you are in sheet 1, that the x is in column B1 and the column you want to populate is F, go now to where you want that information enter the formula as follow =IF(Sheet1!B2="x",Sheet1!F2,"") "jy" wrote: Hello i'm not sure which function i should use. column A has numbers from 5000 to 5999 column B i have put a "x" in the cell of the row i wish to populate the other worksheet column C last name column D first name and so on in the other worksheet i would like to populate only the row that have the "x" in the cell i would also like to populate only certain column of that row in that new spreadsheet thank you JY |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |