you can concatenate the two cells together to form a single lookup reference:

Example:
=VLOOKUP(A2&"-"&A3,Jan09!A2:D200,2,FALSE)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Faiz" wrote:

I want to take the amount of my expense head 5121 from Worksheet ''Jan09",but
in the same file 5121 is coming with different departments such as
5121-100,5121-120,5121-140 i want to retreive the amount of 5121-281 both are
in two different columns, can anyone solve my problem please