Extract selected Data from workbook to workbook

Originally Posted by leopradeep

i have a main excell workbook in which has a large amount of data
for ex

Fruits rate discount net.rate

Apple 10 10 9
mango 20 20 18
banana 10 20 8
xxxx
xxxx

the above workbook i recieve from someone every day.
------------------------------------------------------------
but i dont want all the details in it, and i always need only a few selected items in a sep workbook
for ex

Fruits net.rate

apple 9
mango 18

how do i extract datas i need in a sep workbook?
----------------------------------------------------------
i tried to create a workbook like this

Fruits net.rate

Apple
Mango

but how do i recieve the net.rate value for individual items in this workbook?

someone plz help me

Hi,

try a VLookup (one for each cell)

=VLookup(A1,DailyBook!A:D,2,False)

where A1 is the Apple in your new book, and 2 is the column B from your Daily book, 3 for column C etc.

hth
---

Originally Posted by leopradeep

thanks 4 the timely help
its working

good to see that it works for you, and thanks for your response.

---