copying specific data from 1 wrksht to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 !
 
Remove the $ from in front of the 3, as follows:

=IF(ISERROR(VLOOKUP($B3,rawdata,1)),"",(VLOOKUP($B3,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
 
Back
Top