Hi,

Which result do you want to return from your example if the identifier is
003359?


--
Thanks,
Shane Devenshire


"cartmr" wrote:

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