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

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

Thanks Luke,

I would try to make my query,more clear to you

Monthly Exp.xlsx

Cloumn 1 Col2 Col3
Expense Heads Dept Amount
5121 100 Formula(Need the data here)
5122 100 Formula(Need the data here)
5123 100 Formula(Need the data here)



Jan09.xlsx

Expense Heads Dept Amount
5121 100 6500.00
5122 100 1215.00
5123 100 200.00
5121 120 3500.00
5122 120 1215.00
5123 120 3250.00
5121 140 2500.00
5122 140 1215.00
5123 140 3150.00

I need in worksheet 1 i.e Monthly exp in column 3 to look(bring) the amount
from sheet Jan09, amount of 5121 where the dept is 100.

It is clearly visible that 5121 head is present with dept 100,120,140 in my
example

Could you please help me on this?

Hope that is clear to you







"Luke M" wrote:

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