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

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
You must log in or register to reply here.

Similar threads

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

Forum statistics

Threads
1,216,952
Messages
6,133,705
Members
449,827
Latest member
tmilton

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