"Picture is too large and will be truncated" getting error

[udprocks]

Dear All,

Can anyone please help me with this i am getting error when selecting brand.

error showing as title of this thread.

Have uploaded a sample file for same.

 

[Gangadhar Yeligaty]

Here is the solution:-

Create two formulas using “Name Manager” in “FORMULAS” menu.

1st Formulas “carlist” =Sheet1!$E$1:$E$4.

2nd Formulas “carlookup” =INDEX(carlist,MATCH(Sheet2!$A$2,Sheet1!$D$1:$D$4,0))

After creating above formals click on the Picture and apply below formulas

=carlookup

And your ready.

Also find the attached corrected file.

Dear All,

Can anyone please help me with this i am getting error when selecting brand.

error showing as title of this thread.

Have uploaded a sample file for same.

 

[udprocks]

Here is the solution:-

Create two formulas using “Name Manager” in “FORMULAS” menu.

1st Formulas “carlist” =Sheet1!$E$1:$E$4.

2nd Formulas “carlookup” =INDEX(carlist,MATCH(Sheet2!$A$2,Sheet1!$D$1:$D$4,0))

After creating above formals click on the Picture and apply below formulas

=carlookup

And your ready.

Also find the attached corrected file.

Thank you ,

Gangadhar its working and correct, but when i m doing it myself again m getting same error.

 

[Somendra Misra]

Hi Jeetendra,

Here are some problems in your file;

1) You had defined a named range cars which is pointing to whole column E, where as it should point to range with data only.
2) You had put the INDEX formula in cell B2 of sheet2, where as that formula should be as named formula as Gangadhar pointed out.

Try making these changes and write back if you have any problem.

Regards,

 

[udprocks]

Hi Jeetendra,

Here are some problems in your file;

1) You had defined a named range cars which is pointing to whole column E, where as it should point to range with data only.
2) You had put the INDEX formula in cell B2 of sheet2, where as that formula should be as named formula as Gangadhar pointed out.

Try making these changes and write back if you have any problem.

Regards,

Hallo Sir,

Good morning,

I have created that sheet as per Gangadhar but still m not able to do it,,
i dont know where m doing mistake.

 

[Somendra Misra]

@udprocks

Upload your sheet.

Regards,

 

[udprocks]

@udprocks

Upload your sheet.

Regards,

See the file plz..

 

[Somendra Misra]

See the file. Move the blank image with formula =carlookup on sheet 2.

Regards,

 

[udprocks]

See the file. Move the blank image with formula =carlookup on sheet 2.

Regards,

Dear SIr,

Thank you for support can u please tell me how to Moving blank image with formula, i am confused..