Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Amanda L
 
Posts: n/a
Default Lookup values in a list and return multiple rows of data

Hi there,

I am trying to lookup data in a column and if it matches a particular value
and want to copy the whole row to a new worksheet. There will be more than
one row that matches the value so I accnot use VLookup. Can anyone suggest
an approach please?

Many thanks,

Amanda
  #3   Report Post  
Alan Beban
 
Posts: n/a
Default

Amanda L wrote:
Hi there,

I am trying to lookup data in a column and if it matches a particular value
and want to copy the whole row to a new worksheet. There will be more than
one row that matches the value so I accnot use VLookup. Can anyone suggest
an approach please?

Many thanks,

Amanda

You might want to consider the ArrayRowFilter1 function in the freely
downloadable file at http://home.pacbell.net/beban.

Alan Beban
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 08:11 PM
find rows for unique data in 1 column and different data in other. Dot Majewski Excel Discussion (Misc queries) 1 January 21st 05 01:23 AM
Pivot Table Zero Value jcliquidtension Excel Discussion (Misc queries) 12 January 13th 05 05:21 AM
Data Format: how can I re-format TexasDon New Users to Excel 2 December 28th 04 07:21 AM
double lookup, nest, or macro? Josef.angel Excel Worksheet Functions 1 October 29th 04 09:50 AM


All times are GMT +1. The time now is 04:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"