referencing information in a table

  • Thread starter Thread starter dethstar
  • Start date Start date
D

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
 
=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)
 
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


Bob said:
=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]
Click to expand...
 
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)

dethstar > said:
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


Bob said:
=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
Click to expand...
Click to expand...
 
Hehe



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

it works perfectly thanks very much for your help
 
Back
Top