lookup

[jy]

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

 

[Pete_UK]

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

 

[Eduardo]

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,"")