Dear friend,
I think there is also some problem with sheet name".xls]ratelist" as sheet
name can not have "]" . still i will suggest the solution that name the
array and then apply vlookup it will work. I have tried it.
rgds
Mayank
On Sat, Aug 30, 2008 at 2:38 PM, Palani Durai <[EMAIL PROTECTED]>
Hi Yasir,
I do recognize, there is a simple solution im seeing is that you have create
a unique ID of the combination of "Code" & "Color" based on that you can
have your values by vlookup.
the sheet is attached herewith...
On 8/30/08, yasir_shahjee <[EMAIL PROTECTED]> wrote:
>
> Dear pala
