Thread: Table Lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alister Gough[_2_] Alister Gough[_2_] is offline
external usenet poster
 
Posts: 4
Default Table Lookup

I need help with a lookp I need to do. This lookup needs to lookup a table
that may contain the same data more than once and then add the values
together.

E.g. The table might look like this:

Table Game Hours
PK01 Holdem 8
PK02 Omaha 3
PK03 Draw 11
PK04 Holdem 2

So the formula I need would have to lookup the value which might be holdem
and return the value 10 (8 + 2).

Is there anyway t do this?