v lookups

[bob1988]

i hope this is in the right forum sorry if it's not.

for my it project at school we have to create a spreadsheet now i hav
nearly finished but i need to put a v lookup in.

what i was wondering was can a v lookup be used say in a order form an
everytime you type in a code it automatically brings up the name of
product and price.

if so could somebody please tell me how because its got to be given i
friday

 

[JudithJubilee]

That is exactly what it is used for.

The formula is :

=VLOOKUP(LookupValue, Array, IndexNumber,FALSE)

The LookupValue is the cell you are trying to find out
about, in your it will be the cell into which you type
the product code, eg.A100 The array is the data which
you are searching. It need to be laid out with the
Product code as the first column, eg.

Product Code Name Price
A123 Pens £1.50
B235 Paper £2.50
C267 Tippex £5.50

Before you do the formula you need to highlight the
array, without the headings. In this case it would be
A2:C4. Give this range a name be clicking in the Name
box to the left hand side of the Formula bar. Call it
Array, (just as an example).

The IndexNumber is the column from which you would like
the information. The word FALSE at the end tells Excel
to give you an error message if it cannot find an exact
match.

For Name:

=VLOOKUP(A100.array,2,FALSE)

For Price:

=VLOOKUP(A100.array,3,FALSE)

I hope this helps

Judith

 

[Alan Beban]

Or for Name and Price, array enter (i.e., enter into a 2-cell row with
Ctrl+Shft+Enter instead of just Enter), e.g.,

=VLOOKUP(code,DataRange,{2,3}FALSE)

Alan Beban

 

[Trevor Shuttleworth]

Alan

I'm guessing there should be another comma there: ...},FALSE) ?

=VLOOKUP(code,DataRange,{2,3},FALSE)

Regards

Trevor

 

[Alan Beban]

Of course; my sloppiness.

Alan Beban

Alan

I'm guessing there should be another comma there: ...},FALSE) ?

=VLOOKUP(code,DataRange,{2,3},FALSE)

Regards

Trevor