I'm trying to return a figure from a row using a lookup however, the data in column a may repeat. For example, one account number may appear 3 times in column a but the data in the corresponding row will be different. I am not sure which lookup feature I can use since vlookup isn't doing it...any help?