Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying specific data from 1 wrksht to another
I have 1 tab of "raw data" and would like to extract only rows of data with
specific values. I am using this formula currently: =IF(ISERROR(VLOOKUP($B$3,rawdata,1)),"",(VLOOKUP($ B$3,rawdata,1))) but it will only return 1 row of data, and when I copy the formula down, I just get the same data all the way down .... HELP ! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying specific data from 1 wrksht to another
Remove the $ from in front of the 3, as follows:
=IF(ISERROR(VLOOKUP($B3,rawdata,1)),"",(VLOOKUP($B 3,rawdata,1))) then copy this down - you will have $B4, $B5, $B6 etc in the next few cells. I assume "rawdata" is a named range in the other sheet. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying filtered data to another Excel Spreadsheet | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) |