Extending VLOOKUP
 

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

Extending VLOOKUP
 

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

Extending VLOOKUP
 

Assume your data is in A1:D10 (month, acct number, store, amount). F1 is the
account number your looking for and G1 is the store you are looking for, try:

=INDEX(D1:D10, MATCH(F1&G1, B1:B10&C1:C10, 0))

After typing it in, you must hold down the Cntrl and Shift keys while
pressing Enter.

Alternatively, you can insert a column and create a new column using =C1&D1
(acct number & store number) and use this new column for your VLOOKUP.

Where F1 is the account number your looking for and G1 is the store you are
looking for:

=VLOOKUP(F1&G1, A1:E10, 5, FALSE)


"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