LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SMH SMH is offline
external usenet poster
 
Posts: 29
Default Find Matching Data Within Numerous Rows

There are two sets of data with one field matching in both sets. I want to
be able to put a formula into a cell and find the matching field, whether it
is in cell 10 or cell 1000. I've tried vlookup, but I'm not getting the
results I was looking for. Any other suggestions.
 
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
Find matching data in two workbooks franklinbukoski Excel Worksheet Functions 1 May 5th 08 10:08 PM
Formula to Find Matching Data NM Excel Worksheet Functions 2 November 15th 07 05:06 PM
Merge data from numerous rows in one column [email protected] Excel Discussion (Misc queries) 1 October 18th 07 11:10 PM
Find Matching Data Two Columns Gilly Excel Worksheet Functions 1 December 1st 06 09:11 PM
Find rows matching Max value Serena Excel Discussion (Misc queries) 3 July 19th 06 02:42 AM


All times are GMT +1. The time now is 03:00 PM.

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

About Us

"It's about Microsoft Excel"