I am compering the content of a cell agains another group of cells and when
it finds a match, I need the formula to return data from a specific cell on
the right hand side and one or more cell daown from it.
This is what I have so far but final yet.

=IF(ISBLANK($C30),"",VLOOKUP($C30,Data!$A$1:$C$871 ,2,FALSE))

How can I do this.
Thanks,
--
When it commes to machinning, I am the BEST