calling all experts (Vlookup?)

Try using the if command in the cells instead e.g. type the following formula into sheet2 B1 and then drag it into cells c1 through aa1 and then down through the rows

=IF(A1=Sheet1!A1,Sheet1!B1,"")

Paul

Doesn't Work, but good try.

"

I've the impression that you want to get rid off duplicates entries in Sheet1. Am I close?

Aladin

============

Aladin Akyurek thanks for the interest

Thanks for responding. I really hope you can help. Sheet1 column A are all unique part numbers as is the data through columns Z. the data in columns b:z is unique to the part number in column A.

What I'm trying to do in sheet2 is have excell find the part numbers in column A sheet2 and then copy the data that is unique to it ie. B:Z which is in sheet1 and paste it right next to it in sheet2.

The main difference is that in sheet1 the part number is unique along with the data through column z. In sheet2 i may have a particular part number listed 4 different times. And i'm trying to have excel recognize the part number and then get the corresponding data in sheet1.

Vlookup will work if i put it in each cell in sheet2 but it slows down excel and the file size grows to be masssive.

I don't know whether I need VBA laguage / macro?

I sure hope you can help.

Re: Aladin Akyurek thanks for the interest

I've apparently misread the question. You are not trying to eliminate duplicate rows from Sheet1 (there are no duplicates there). Quite the opposite. You want to intentionally create duplicate records in Sheet2 possibly for a subset of part numbers. But why would you that? Since you have everything in Sheet1, why do you need Sheet2?

Aladin

=============================

Re: Aladin Akyurek thanks for the interest

there are a number of calculations that have to be made based off the information contained on sheet1. The part numbers are really approval numbers that appear on sheet1 with pricing that is variable based of off delivery volumes that only appear on sheet2 and which are identified by the approval number.

Parts and Orders

This will sound strange, but it's a serious proposal.

You have in fact 2 tables which together makes a relational database, which are connected via the field "approval number". The first one contains apparently basic info about parts and the second orders related to parts. I'd suggest keeping them apart and not to repeat in Sheet2 (ORDERS) the info that is available in the other (PARTS).

If you need any info from PARTS (Sheet1) in order to do a computation in ORDERS (Sheet2), pull that info directly by using VLOOKUP from PARTS (Sheet1) into the formula in ORDERS (Sheet2) that does the computation as in

=qty*VLOOKUP(part-num,PARTS,PriceColumn,0)

where qty is a number in ORDERS (Sheet2), part-num (or approval-num) in ORDERS (Sheet2), price in PARTS (which gets retrieved with VLOOKUP).

The advantages are obvious in terms of memory/storage and processing speed.

What do you think?

Aladin

=======

Re: Parts and Orders

You it the nail on the head. "memory/storage and processing speed" is the problem. I have done what you are proposing many times for other applications. However, it won't work here because of the memory/storage issue. So what I was trying to do is get the approval data right next to the delivery data without using a serious calucation/formula. Any ideas?

I have a similar situation. I have 9000 records of data, 3 columns. In a second sheet I want to do a VLOOKUP to find a part number and return a value next to it. The problem is that VLOOKUP stops when it finds a match, it won't continue to look at the next row. In my case there is not a field that is unique, no key index. Is there a way to force VLOOKUP to continue to look for more matches?

Care to post 15 rows of your data from the 3 columns you mention?

Aladin