N
newriver
what would be the process to enter product numbers in one field and have the
product description appear in the next field to the right
product description appear in the next field to the right
O
Otto Moehrbach
First you would create a table (that you probably already have) containing
the product number and the product description. Then in the second cell
(where you want the product description to appear, use a VLOOKUP formula.
Look it up in Help. HTH Otto
the product number and the product description. Then in the second cell
(where you want the product description to appear, use a VLOOKUP formula.
Look it up in Help. HTH Otto
B
Bill Kuunders
You need a 2 column table of numbers and descriptions
use the vlookup function to get the description
I.e. something like =VLOOKUP(B1,$C$1:$D$11,2,false)
where
B1 is your cell with the number
C1
12 is the range with the table
2
is the column to look in
false indicates you need an exact match
the numbers in C column should have been sorted ascending
use the vlookup function to get the description
I.e. something like =VLOOKUP(B1,$C$1:$D$11,2,false)
where
B1 is your cell with the number
C1
12 is the range with the table2
is the column to look in
false indicates you need an exact match
the numbers in C column should have been sorted ascending