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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
You must log in or register to reply here.

Similar threads

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

Forum statistics

Threads
1,223,897
Messages
6,175,270
Members
452,628
Latest member
dd2

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