Remember Me?

#1
March 8th 06, 03:04 PM posted to microsoft.public.excel.worksheet.functions
 Space Elf Posts: n/a
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
March 8th 06, 03:55 PM posted to microsoft.public.excel.worksheet.functions
 Domenic Posts: n/a
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 \$\$\$

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post ultra vires Excel Discussion (Misc queries) 2 March 3rd 06 09:26 AM smoore Excel Worksheet Functions 12 February 27th 06 03:43 PM Dinesh Excel Worksheet Functions 6 February 9th 06 11:20 PM Tomszar Excel Discussion (Misc queries) 3 December 30th 05 02:48 PM M Skabialka New Users to Excel 2 March 11th 05 02:52 AM

All times are GMT +1. The time now is 01:11 PM.