Krish:

If the data sits on the same record as it should, then, simply drop the
VLOOKUP function in the cell you want pointing to the target columns and ref
to column you want something like:

(1) =IF(ISNA(VLOOKUP(S5,IncomeTax,2)),"",VLOOKUP(S5,In comeTax,2))
(2) =IF(ISNA(VLOOKUP(S5,IncomeTax,3)),"",VLOOKUP(S5,In comeTax,3))
(3) =IF(ISNA(VLOOKUP(S5,IncomeTax,4)),"",VLOOKUP(S5,In comeTax,4))

Notice the last ref chages (2,3,4) to point to column of data you want the
data to come from!

"Krish" wrote:

I have a database with month,account number,store location and amount. I am
trying to populate a Budget. I have the % Increase for each account number
and they vary by store location. I was able to use VLOOKUP to get the Budget
figures, but I do not know how to add another condition to look for the
store location.
Thanks.
Krish