Insert a helper column in which you cancatenate the two keys. Concatenate
the search arguments too.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"yimmin" wrote in message
...
Arrrggghhh

I'm tearing my hair out with this one.

I need to create a formula that will look up the data from 2 seperate
cells
in 2 colums and return the corresponding value in the 3rd colum.

Can anyone help?