Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array with two criteria | Excel Discussion (Misc queries) | |||
List date adjacent to duplicates? | Excel Worksheet Functions | |||
How can find a value using two different matching criteria? | Excel Worksheet Functions | |||
Change the appearance cell where Find criteria is found in a cell | Excel Discussion (Misc queries) | |||
How do I find a value in an array (VLOOKUP? HLOOKUP?) | New Users to Excel |