Lookup based on 2 values

[djdiplomat]

Hi

I'm looknig for a way to perform a dual lookup.

e.g.


Range would be:

Column A contains an account name, column B contains a product code, column C contain a value.


Lookup Formula would need to look account name, then product code and return the corresponding value.

Can anyone push me in the right direction please?

Thanks

Will

 

[baodinh]

Will, Insert a new column A. Concatenate account and product code in new column A eg: in cell A2, type in formula "=B2&C2" and copy down. Then you can perform you vlookup based on the combined data in column A.

 

[djdiplomat]

Will, Insert a new column A. Concatenate account and product code in new column A eg: in cell A2, type in formula "=B2&C2" and copy down. Then you can perform you vlookup based on the combined data in column A.

This will work - thanks.

But is there a formula that will perform dual lookup (VLOOKUP, MATCH, INDEX etc?)

Would be good if I didn't have to Concatentate as I'm working with multiple data sources.