Need formula that looks in a range for a date and acct # 1

[Wknwrkr]

Is there a formula that looks in a range of cells for both a date and an account # and returns a cell value. I want the formula to say find this date 9/1/08 and this account number 40105-200 and return the cell value in the corresponding column. The dates of the month are in one column, the account numbers are in another column, and the amounts are in the third column. VLOOKUP only looks for one value, but I need it to return the value based on both criteria.

 

[petrosky]

Hi there,

Try this link for a simple example of what you are trying to achieve.

http://jldexcel.blogspot.com/2006/01/vlookup-with-multiple-criteria.html

HTH.

Peter.

Remember- It's nice to be important,
but it's important to be nice

 

[xlbo]

You can also use SUMPRODUCT for this - lots of examples in posts in this forum

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Wknwrkr]

Thank you...but i'm still having problems. I am going to try and upload the spreadsheet so you can see what I am talking about.
The Monthly Data tab is where a .txt file is going be pasted each day. Each day is pasted on the next row (so the sheet will end up being thousands of rows long). Then what I need to do is have formulas on the Daily tab that will search the information on the Monthly Data tab and insert to each column (by date) as the information is pasted daily.
I tried to attach the spreadsheet...I hope this works...I'm running out of time.
Thanks in advance!!