Thread: How do I use " V Lookup" to transfer data to a new workbook ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo
 
Posts: n/a
Default How do I use " V Lookup" to transfer data to a new workbook ?
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:

I need to transfer part prices and description to different large spreadsheets.
Reply With QuoteReply With Quote