Assuming your basic data sheet is called data, then put this formula
in C2 of your other sheet:

=IF(ISNA(MATCH(B2,data!A:A,0)),"",VLOOKUP(B2,data! A:B,2,0))

Then copy this down as far as you need.

Hope this helps.

Pete

On Mar 24, 5:18*pm, Cody wrote:
I apologize, that didn't come out looking right.

It's essentially five columns followed by a bunch of rows. *The five columns
are as follows: *1. Quantitiy 2. Part Number 3. Description 4. Price per Unit
5. Total Price

I have no problem inputting the quantity, part number, and price per unit.. *
The total price automatically calculates based on the quantity. *But I need
help auto-populating the description so I don't have to type it in every
time. *The worksheet I'm wanting to retrieve this from is a basic data shee
with two columns: 1. part number 2. description. *So essentially I would like
the first work sheet to populate the description from the data sheet by
matching the part number. *

Thanks!



"Francis" wrote:
Hi

This is possible. I need to see your table layout
can you provide a small sample and the result you want
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another

"Cody" wrote:

I have a sales order form that has an area for part number and description. *
When I type in the part number I would like it to auto-populate the
description from my parts list I have on another work sheet. *Is this even
possible? *I would appreciate any help!- Hide quoted text -

- Show quoted text -