There is data like this in excel:
Q C C C
A 10 100 110 150
B 20 300 330 370
C 30 200 220 150
D 40 700 777 900
A 50 50 55 60
B 60 2000 2200 3000
C 70 770 900 1000
E 80 80 10 88
F 30 222 333 100
A 50 123 532 254
C 60 25 35 45


I want to import some Item data and and Q from another excel file and place
it in 6 th and 7th columns. Next column I need to estimate the cost for the Q
that is in the 7th column using the data in the first 5 columns.
Like say, if some B, C and D are imported, I need to put a Vllokup function
and also a forecast function together, where using vlookup it will search all
the same B, or same C, or Same D items, and then puts the forecast function
for that data ..

Can it be done like this in any way

Hi Vijaya,
You would need to define your problem better before you can solve it,
but take a look at VLOOKUP, INDEX, and MATCH Worksheet Functions.
This may be of help http://www.mvps.org/dmcritchie/excel/vlookup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"vijaya" wrote in message ...
There is data like this in excel:
Q C C C
A 10 100 110 150
B 20 300 330 370
C 30 200 220 150
D 40 700 777 900
A 50 50 55 60
B 60 2000 2200 3000
C 70 770 900 1000
E 80 80 10 88
F 30 222 333 100
A 50 123 532 254
C 60 25 35 45


I want to import some Item data and and Q from another excel file and place
it in 6 th and 7th columns. Next column I need to estimate the cost for the Q
that is in the 7th column using the data in the first 5 columns.
Like say, if some B, C and D are imported, I need to put a Vllokup function
and also a forecast function together, where using vlookup it will search all
the same B, or same C, or Same D items, and then puts the forecast function
for that data ..

Can it be done like this in any way