Formula/Macro lookup comment/image

E

exceleratevba

New Member
Joined
Feb 27, 2017
Messages
11
Hi,

I've got a workbook that I'm trying to have lookup a cell with a comment and image.

If I enter data into the first sheet in A2, I'd like it to populate the corresponding comment and image from the second sheet in column H into the first sheet in column F2.

https://www.photobox.co.uk/my/photo?album_id=5533511194&photo_id=501512426762

https://www.photobox.co.uk/my/photo?album_id=5533511194&photo_id=501512427042

Thank you

Cross posts links below

https://www.excelguru.ca/forums/show...ed=1#post39793

https://www.excelforum.com/excel-pro...ml#post5032908
 
Last edited by a moderator:

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
You must log in or register to reply here.

Similar threads

T
  • Question
Lookup within a lookup
2
Replies
10
Views
333
TimeForTim
T
S
  • Question
VBA Code to Copy Dashboard Date Data, Lookup that Date on YTD Data tab, and Paste Value?
Replies
1
Views
253
SirGruffles
S
S
  • Question
Repeating a pivot table many times and changing only one column -- are there more efficient approaches?
Replies
0
Views
219
sschaefer
S
P
  • Question
How can I copy comments to other sheets in a workbook using VBA
Replies
1
Views
457
mumps
mumps
M
  • Question
Formula to populate the next available cell in a column using data populated in another cell.
Replies
4
Views
410
Marshkevuk
M

Forum statistics

Threads
1,215,771
Messages
6,126,798
Members
449,337
Latest member
BBV123

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top