MyLocn = Sheets("Data").Range("J1").Offset(WorksheetFunction.Match(Sheets("Info Sheet").Range("selected_part"), Sheets("Data").Range("A:A"), 0) - 1)
MyLocn = Range("E2").Offset(WorksheetFunction.Match(Range("B2"), Range("D2:D3"), 0) - 1)
Book19 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | What to Look Up | Lookup Table | |||||
2 | Picture 1 | Picture 1 | C:\pic1.jpg | ||||
3 | Picture 2 | c:\pic2.jpg | |||||
Sheet1 |