it seems to me that a VLOOKUP() should work for this problem. did you try it?

"Aligahk06" wrote:

Dear All,

I have a problem with following description.
I want to fill unit price in the Shaded in Col G Based on Col A.
Col A is a Line Item Upto 1280. i.e 10,20,30,40.........1280 and want to
fill corresponding cell of Col G.
The Price list is stored into Sheet2 with following format.
fOR LINE iTEM 10 To 80 total eight values is picked from Eight col from
sheet 2.
i.e. Column C6 to ColJ6 Horizontally(C6,D6,....J6)
for line item 90 to 160 total eight values picked from
Sheet2 Column C6 to ColJ6 Horizontally(C7,D7,....J7) and so on.

Can i do this by UDF or Simple Function or vba.

Please assist?

Rgds,
Alighak06