VLookup function

[bigduke6]

Good Morning Gentlemen,

I am in the process of coverting a fixed asset database to a new software package. The first step was to break out part numbers from the description and put in a column by them self. The part number also has an asset id in a seperate column. The first conversion failed to happen and I am restarting the entire process with fresh data. I want to avoid having to key in the thousands of part numbers from the description again or do any copy and pasting in mass amounts. Is there any way v lookup can match the part number and asset id from the first spread sheet and assign the part number to the asset id on my new spread sheet.

Thanks, Eddie

[NBVC]

So you have a list of assets on both sheets, and you have a list of part ids only in one sheet. You want to match the asset numbers and pull the appropriate part ids? Is that correct?

[bigduke6]

So you have a list of assets on both sheets, and you have a list of part ids only in one sheet. You want to match the asset numbers and pull the appropriate part ids? Is that correct?

Yes Sir....

[NBVC]

Assuming then, that the List of Assets and corresponding Part IDs is in Sheet1, A1:B100

try:

=Vlookup(A2,'Sheet1'!$A$1:$B$100,2,FALSE)

Where A2 is first asset to look for in the other sheet, adjust ranges to suit.

If you have assests in column B and parts in column A, then try:

=INDEX('Sheet1'!$A$1:$A$100,MATCH(A2,'Sheet1'!$B$1:$B$100,0))

[bigduke6]

Assuming then, that the List of Assets and corresponding Part IDs is in Sheet1, A1:B100

try:

=Vlookup(A2,'Sheet1'!$A$1:$B$100,2,FALSE)

Where A2 is first asset to look for in the other sheet, adjust ranges to suit.

If you have assests in column B and parts in column A, then try:

=INDEX('Sheet1'!$A$1:$A$100,MATCH(A2,'Sheet1'!$B$1:$B$100,0))

Success !! Thank You NBVC