Thread: Formula nesting - V & H Lookup

Hi,

Pls help me out by providing a formula to nest Vlookup & Hlookup. Herewith enclosed some datas to workout.

Pls do the needful.

Thanks in advance.

Regards,
Arun

Maybe if you could change name to be consistant:

Also this solution assume that Calling is above Leads.
If that's not true, in other words if this can change, then you'll need one more MATCH function.