Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 8th 06, 03:04 PM posted to microsoft.public.excel.worksheet.functions
Space Elf
 
Posts: n/a
Default In an array, I need to find the row # that meets 2 criteria

One sheet contains data that includes dates, vendor, price, and other items
in each row. I need to find the row offset that will match a date with a
vendor. I have tried using match, but since some dates and vendor names are
the same, I can't seem to isolate a matched pair everytime. Also, there are a
few times when there are duplicates of both and I need to get the next
matched set in the array.

DATE VENDOR CHARGE
date 1 vendor 1 $$$
date 1 vendor 2 $$$
date 2 vendor 1 $$$

  #2   Report Post  
Old March 8th 06, 03:55 PM posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default In an array, I need to find the row # that meets 2 criteria

Assuming that A2:C3 contains your data, and that you'd like to return
the corresponding value in Column C, try...

=LOOKUP(2,1/((A2:A5=E2)*(B2:B5=F2)),C2:C5)

....where E2 contains the date of interest, and F2 contains the vendor of
interest.

Hope this helps!

In article ,
Space Elf wrote:

One sheet contains data that includes dates, vendor, price, and other items
in each row. I need to find the row offset that will match a date with a
vendor. I have tried using match, but since some dates and vendor names are
the same, I can't seem to isolate a matched pair everytime. Also, there are a
few times when there are duplicates of both and I need to get the next
matched set in the array.

DATE VENDOR CHARGE
date 1 vendor 1 $$$
date 1 vendor 2 $$$
date 2 vendor 1 $$$



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
Array with two criteria ultra vires Excel Discussion (Misc queries) 2 March 3rd 06 09:26 AM
List date adjacent to duplicates? smoore Excel Worksheet Functions 12 February 27th 06 03:43 PM
How can find a value using two different matching criteria? Dinesh Excel Worksheet Functions 6 February 9th 06 11:20 PM
Change the appearance cell where Find criteria is found in a cell Tomszar Excel Discussion (Misc queries) 3 December 30th 05 02:48 PM
How do I find a value in an array (VLOOKUP? HLOOKUP?) M Skabialka New Users to Excel 2 March 11th 05 02:52 AM


All times are GMT +1. The time now is 09:09 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017