View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vanslanzar vanslanzar is offline
external usenet poster
 
Posts: 1
Default Returning a value from the same row using two variables

Is there a way to return a value from a row using two variables from the same
row?

For example

Account# Date Value
1 1/1/00 2
1 1/2/00 2

I'm trying to use vlookup but its not able to differentiate the same account
number but different dates. I want to set a range on cells and have cell
references for the account number and dates and just have the function return
the value. Any help would be appreciated. Thanks!