+ Reply to Thread
Results 1 to 2 of 2

Ordering rows

  1. #1
    Registered User
    Join Date
    08-10-2010
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Ordering rows

    Hello,

    I'm not sure what to call what im trying to do, but ill try my best to explain it.

    I have a column with Product codes such as;
    001
    002
    003 and so on.

    I also have another column with image names for those products, but my problem is I dont have images for all the products. so my column looks like
    001.jpg
    003.jpg
    005.jpg
    006.jpg

    Is there any way possible to have those images go to their correct row?

    Thank you.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Ordering rows

    try this: assumptions: product codes in column A, JPG names in column D. In B1 use

    =IFERROR(VLOOKUP(A1&".jpg",$D$1:$D$100,1, FALSE),"")

    copy down

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1