View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cartmr cartmr is offline
external usenet poster
 
Posts: 2
Default Using v-lookup with multiple identifiers

I am trying to get results from a vlookup table but I have multiple
identifiers with the different results.

E.g.

EMPX Amount
003359 $1,288.74
003359 $545.23
003359 $214.77
004200 $197.87

How can I get the v-lookup to return one results for each EmPX? I am trying
to reconcile 2 seperate spreadsheets