referencing information in a table

[dethstar]

Hi

i am first time posting newB me.

Basically i have a sheet information which is a price list sorted b
part number, the other columns have price descriptions and othe
information in.

on another sheet i want to be able to type a part number and have
formula copy the relevant description from the table on the previousl
described sheet.

the format of the information table is column A has all part numbers i
it, and i want to copy said description from column C.

now ive had a long time fiddling with this and so far have only manage
to find what row i would need to copy from using the "MATCH" function
ie i type in the part number and the formula finds what row th
desciption and part number are on. after that im stuck.

the formula so far is:

=MATCH(B1,Sheet1!A1:A5,FALSE)

(B1 is where i'm inputting the part number for search).

any help would be very appreciated.

thanks

 

[Bob Phillips]

=INDEX(Sheet1!$C$1:$C$5,MATCH(B1,Sheet1!$A$1:$A$5,FALSE),1)

or

=VLOOKUP(B1,Sheet1!$A$1:$C$5,3,FALSE)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[dethstar]

Hi

thanks for the help, i have tried these, but it doesn't copy th
description text from the cell it finds, as far as i understood it i
just tells you if anything matches.

anyway when i used the formulae it just resultd in a 1 in the cell.

any other ideas, i'm stumped.

thanks

=INDEX(Sheet1!$C$1:$C$5,MATCH(B1,Sheet1!$A$1:$A$5,FALSE),1)

or

=VLOOKUP(B1,Sheet1!$A$1:$C$5,3,FALSE)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

message
news:[email protected]...[color=blue[/QUOTE]

 

[Bob Phillips]

It should, and it does in my tests. Don't know where that came from.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi

thanks for the help, i have tried these, but it doesn't copy the
description text from the cell it finds, as far as i understood it it
just tells you if anything matches.

anyway when i used the formulae it just resultd in a 1 in the cell.

any other ideas, i'm stumped.

thanks

=INDEX(Sheet1!$C$1:$C$5,MATCH(B1,Sheet1!$A$1:$A$5,FALSE),1)

or

=VLOOKUP(B1,Sheet1!$A$1:$C$5,3,FALSE)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

message

 

[dethstar]

Hehe



its my mistake. the desciption column had a 1 in it.

it works perfectly thanks very much for your help