Vlookup

  • Thread starter Thread starter valerie
  • Start date Start date
V

valerie

How to go abt using VlLOOKUP function for Reorder Remark, if;

Reorder Remark depends on the number of units of Stock Balance as
follows:

_Stock_Balance_
10 or less
11-15
More than 15

-Reorder Remarks-
Order now
Order ASAP
Need not ordee

Thanx
 
valerie said:
How to go abt using VlLOOKUP function for Reorder Remark, if;

Reorder Remark depends on the number of units of Stock Balance as
follows:

_Stock_Balance_
10 or less
11-15
More than 15

-Reorder Remarks-
Order now
Order ASAP
Need not ordee

Thanx
Click to expand...

Make a table somewhere (let's say in A2:B4) with the minimum stock balance
figures for each remark alongside the corresponding remarks. So, A2:A4 would
contain 0, 11, 16 and B2:B4 would contain Order now, Order ASAP, Need not
order.

Then, let's say your stock balance figure was in D1. The formula you would
need (perhaps in E1) is
=VLOOKUP(D1,$A$2:$B$4,2)
For further stock balances in D2, D3, etc., just copy this formula down the
column.

You should be able to adjust the ranges to whatever you want in your
particular layout.
 
Back
Top