Thread: Help with multiple conditions with lookup table
View Single Post
  #2  
Old 11-08-2006, 10:26 PM
duane duane is offline
Forum Guru
  
Join Date: 11 Jul 2004
Posts: 847
duane is an unknown quantity at this point
without looking at your file, assuming your two criteria are in columns a and b, and the table is 10 rows long, starting in row 1
criteria are in cells d1 and e1

=offset(c1,match(1,(a1:a10=d1)*(b1:b10=e1),0)-1,0)

entered with control+shift+enter
__________________
not a professional, just trying to assist.....
Reply With Quote