Excel macros, pictures, linking sheets

[jenlion]

I need some help putting together some things in an excel sheet. I'm about ready to go home and just do it in VB, but they want it in excel, and I'm sure it can be done -- I just don't know how yet.

Sheet has rows consisting of an item number, a picture of the item, and a description. The item number is given. The item description is in another excel sheet elsewhere, and the item number cell contents match. I want to tell the current sheet to go look at that other sheet, find the row that has the same item number, and bring me back the description -- and do this for each row that has an item number.

That's the easy part. I also need to put a picture in each row. The file name is the same as the item number. Again I need to do this in each row. Since pictures appear to sit on top of the sheet rather than act as part of a cell, I'm not sure this is even possible.

If anyone has input, a place to start, or a place to look for examples, I'd appreciate the help.

 

[mmtraining]

Take it as read that the cursor is in B2 on some sheet or other. The cell with the item number is A1 on that sheet. The list of the item numbers and the descriptions is on the sheet called Table 2 and is in a1 to B6:

=VLOOKUP(A1,'Table 2'!$A$1:$B$6,2,FALSE)

Vlookup is a vertical lookup in a list.

I always say it like text:
Is vlookup,

=VLOOKUP

open brackets,

(

look in there,

A1

then hop to the list and freeze it,

,'Table 2'!$A$1:$B$6

then make sure the search looks exactly and doesn't need the list to be sorted,

,FALSE

close brackets,

)

enter

Then you can drag the result down from the bottom righthand corner. Being as you froze the list on Table 2 (using <F4>), the cell you have the item number in is relative, the list of data is fixed.

The picture is a bit more difficult, I'd have to see an example spreadsheet:

carol@fernschulung.de

My first idea would be to try the VLOOKUP on that as well, if the picture is anchored in a cell.

All the best,

Carol, Berlin