How do I use " V Lookup" to transfer data to a new workbook ?

M

Marcelo

HI

=vlookup(a2;otherws!a1:z1000,2,0)
=vlookup(a2;otherws!a1:z1000,3,0)

2 for the 2nd column
3 for the 3rd column, etc

assuming that the corresponding part code are in the column A (a2 as an eg)

hth
regards from Brazil
Marcelo


"LZ!FQ1" escreveu:
 
F

Franz Verga

LZ!FQ1 said:
I need to transfer part prices and description to different large
spreadsheets.
Click to expand...

I suppose you have 3 columns in your origin workbook: code (column A),
description (column B) and price (column C), while in your destination
workbook I suppose you have a column code (column A); in your destination
workbook in the row of first code type this formula (I suppose is the row
2):

=VLOOKUP($A2,[Workbook_origin.xls]Sheet1!$A:$C,ROW(A$2),0)

Now you can copy through rows and columns


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Top