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

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
You must log in or register to reply here.

Similar threads

T
  • Question Question
Lookup within a lookup
2
Replies
10
Views
777
TimeForTim
T
K
  • Solved
VBA in User Form. Xlookup formula for Dependent Combo Box.
Replies
8
Views
377
Kscoof
K
S
  • Question Question
VBA Code to Copy Dashboard Date Data, Lookup that Date on YTD Data tab, and Paste Value?
Replies
1
Views
424
SirGruffles
S
S
  • Question Question
Repeating a pivot table many times and changing only one column -- are there more efficient approaches?
Replies
0
Views
465
sschaefer
S
P
  • Question Question
How can I copy comments to other sheets in a workbook using VBA
Replies
1
Views
796
mumps
mumps

Forum statistics

Threads
1,224,823
Messages
6,181,184
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

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