hi,
i want to use vlookup formula for shape withot macros.
there is a file attach (sample) on this coment that is explain for this post.
thanks for your attention.
hi,
i want to use vlookup formula for shape withot macros.
there is a file attach (sample) on this coment that is explain for this post.
thanks for your attention.
Try
Formula:Please Login or Register to view this content.
Change color part with 3 only .
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
No, you can't do that. Shapes don't sit in cells. They appear like sitting in cells but in reality shapes just takes the position as source instead of cell area.
When the shape doesn't reside inside the cell then functions can't do anything when cell is empty.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
is there any way to attributing shape into a cell?
You can do a lookup of a picture. take a look at this sheet. Is this close enough for you?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
For shape, you can do by define "Name Manager".
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks