insert images based on file names matching row cell value

dhruneedshelppls

New Member
Joined
May 3, 2021
Messages
1
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
I want to insert images into the column "image" where the image's name is the number in the column "id". The image should be inserted in the row of the number.

The images are formatted as so:

C:\Users\Dhruvil\Downloads\Cool Stuff\Inner Wellness\TK\12582.jpg
C:\Users\Dhruvil\Downloads\Cool Stuff\Inner Wellness\TK\12582.jpg
C:\Users\Dhruvil\Downloads\Cool Stuff\Inner Wellness\TK\12582.jpg

I have attached the excel file with the numbers and the spots for the images.


12346
12347
12348
12349
12350
12351
12352
12353
12354
12355
12356
12358
12359
12360
12361
12363
12364
12365
12366
12367
12368
12370
12371
12372
12375
12377
12378
12379
12380
12381
12382
12384
12385
12389
12390
12392
12394
12396
12398
12400
12407
12409
12410
12411
12412
12413
12414
12415
12416
12417
12418
12419
12420
12421
12423
12424
12425
12426
12427
12428
12429
12430
12431
12432
12433
12435
12436
12438
12439
12440
12441
12442
12443
12451
12452
12453
12454
12455
12456
12457
12458
12459
12460
12461
12462
12463
12464
12465
12466
12467
12468
12469
12470
12471
12472
12474
12475
12476
12477
12478
12479
12480
12481
12482
12484
12485
12486
12488
12489
12491
12492
12493
12494
12495
12496
12497
12499
12500
12501
12502
12503
12504
12505
12506
12507
12508
12509
12510
12512
12513
12514
12515
12516
12517
12518
12519
12520
12521
12522
12523
12524
12525
12526
12527
12528
12529
12530
12531
12532
12534
12535
12536
12537
12538
12539
12540
12541
12542
12543
12544
12545
12546
12547
12548
12550
12551
12552
12553
12554
12555
12556
12557
12558
12559
12560
12561
12562
12564
12565
12566
12567
12568
12569
12570
12571
12572
12573
12574
12575
12576
12577
12579
12580
12581
12582
12583
12586
12587
12588
12589
12590
12591
12592
12593
12594
12595
12596
12597
12598
12599
12601
12602
12603
12604
12606
12607
12608
12609
12610
12611
12612
12613
12614
12615
12617
12618
12620
12621
12622
12623
12624
12625
12627
12628
12629
12630
12631
12632
12633
12634
12635
12636
12637
12638
12639
12640
12641
12642
12643
12644
12645
12646
12647
12648
12650
12651
12652
12653
12654
12655
12656
12657
12658
12659
12660
12662
12663
12664
12666
12667
12670
12671
12672
12674
12675
12676
12677
12678
12679
12680
12681
12682
12683
12684
12685
12686
12687
12688
12689
12690
12692
12693
12694
12695
12696
12697
12699
12700
12701
12702
12705
12706
12708
12709
12710
12711
12712
12713
12714
12716
12717
12719
12720
12721
12722
12723
12724
12725
12726
12727
12729
12730
12731
12732
12734
12736
12737
12738
12740
12741
12742
12743
12744
12746
12747
12748
12749
12750
12752
12754
12755
12756
12757
12758
12759
12760
12761
12762
12763
12764
12765
12766
12768
12769
12770
12771
12772
12773
12774
12775
12776
12777
12778
12779
12780
12782
12783
12784
12786
12787
12788
12789
12790
12791
12792
12793
12794
12795
12796
12797
12798
12800
12801
12804
12806
12807
12808
12809
12810
12811
12814
12817
12818
12819
12820
12821
12822
12823
12824
12825
12826
12827
12829
12830
12832
12834
12835
12836
12837
12838
12839
12840
12841
12842
12843
12844
12845
12846
12847
12848
12853
12858
12860
12861
12863
12864
12866
12867
12868
12869
12870
12871
12872
12873
12874
12875
12877
12878
12879
12880
12881
12882
12883
12884
12885
12887
12888
12889
12891
12892
12893
12895
12896
12897
12898
12899
12900
12901
12902
12903
12904
12906
12907
12908
12909
12910
12911
12912
12913
12914
12915
12916
12917
12918
12919
12920
12921
12922
12923
12925
12927
12928
12931
12934
12935
12936
12937
12938
12939
12941
12942
12944
12945
12946
12947
12948
12949
12950
12951
12952
12953
12954
12955
12956
12957
12959
12960
12961
12963
12964
12965
12966
12967
12968
12969
12970
12972
12974
12975
12976
12977
12979
12980
12981
12982
12983
12984
12985
12986
12987
12988
12989
12990
12992
12993
12994
12995
12997
12998
12999
13000
13004
13005
13006
13008
13009
13010
13011
13012
13013
13014
13016
13017
13018
13019
13020
13021
13022
13023
13024
13025
13026
13027
13028
13029
13030
13031
13032
13033
13034
13035
13036
13037
13038
13039
13040
13041
13042
13043
13044
13045
13046
13047
13048
13049
13050
13051
13052
13056
13057
13059
13061
13062
13063
13066
13067
13068
13069
13075
13078
13079
13080
13081
13084
13088
13089
13093
13094
13100
13101
13102
13103
13104
13105
13106
13108
13109
13111
13113
13114
13116
13118
13119
13120
13124
13125
13126
13127
13128
13129
13130
13131
13136
13137
13138
13139
13142
13144
13147
13148
13150
13151
13154
13160
13162
13164
13165
13166
13167
13169
13170
13171
13173
13174
13175
13176
13177
13179
13181
13184
13185
13186
13187
13189
13190
13194
13195
13198
13199
13200
13201
13202
13204
13205
13206
13207
13208
13210
13211
13213
13214
13215
13217
13218
13219
13220
13222
13223
13224
13225
13227
13228
13229
13230
13233
13234
13235
13236
13237
13238
13239
13243
13244
13245
13247
13248
13249
13250
13251
13252
13253
13254
13255
13256
13257
13258
13259
13260
13261
13262
13263
13264
13265
13266
13267
13268
13269
13270
13272
13274
13276
13278
13279
13280
13281
13284
13286
13288
13293
13294
13297
13298
13300
13302
13303
13304
13306
13307
13308
13309
13310
13311
13312
13313
13315
13316
13317
13318
13320
13321
13322
13325
13326
13327
13329
13330
13331
13333
13335
13336
13337
13338
13339
13340
13341
13342
13343
13344
13345
13346
13347
13348
13349
13350
13351
13352
13353
13354
13355
13356
13357
13358
13359
13361
13363
13365
13366
13367
13368
13369
13370
13372
13375
13376
13377
13378
13380
13381
13382
13384
13385
13386
13387
13388
13389
13391
13392
13393
13395
13396
13397
13398
13400
13401
13402
13404
13405
13407
13408
13409
13410
13411
13413
13414
13416
13417
13418
13419
13420
13421
13423
13424
13426
13427
13428
13429
13430
13432
13434
13435
13437
13439
13440
13441
13443
13444
13446
13447
13448
13449
13451
13453
13454
13455
13456
13457
13458
13459
13460
13461
13462
13463
13464
13466
13467
13468
13469
13470
13471
13472
13474
13475
13476
13477
13478
13479
13481
13482
13483
13484
13487
13488
13489
13491
13492
13493
13494
13495
13496
13497
13498
13499
13502
13504
13505
13506
13507
13508
13509
13510
13511
13512
13513
13514
13515
13517
13518
13519
13520
13521
13522
13523
13524
13526
13528
13529
13530
13532
13533
13534
13537
13538
13540
13541
13542
13543
13544
13545
13546
13547
13548
13549
13550
13551
13552
13553
13554
13555
13556
13558
13559
13560
13562
13563
13564
13565
13566
13567
13570
13571
13572
13574
13575
13577
13578
13579
13580
13582
13583
13584
13585
13586
13587
13588
13589
13591
13592
13593
13594
13595
13596
13597
13598
13599
13600
13601
13602
13604
13605
13607
13608
13609
13611
13612
13613
13614
13615
13616
13617
13619
13622
13623
13624
13625
13628
13635
13643
13660
13670
13676
13686
13687
13689
13690
13691
13692
13693
13694
13695
13696
13697
13698
13700
13701
13702
13703
13704
13705
13706
13707
13708
13709
13710
13711
13713
13714
13715
13716
13718
13720
13721
13722
13723
13726
13727
13728
13729
13730
13732
13734
13735
13736
13737
13738
13741
13742
13743
13746
13748
13749
13750
13751
13752
13753
13754
13755
13757
13758
13759
13760
13761
13762
13763
13764
13765
13766
13767
13768
13770
13771
13772
13773
13774
13775
13776
13777
13782
13783
13784
13785
13786
13787
13788
13789
13792
13793
13794
13795
13797
13798
13799
13802
13803
13804
13805
13807
13810
13811
13812
13814
13815
13818
13819
13820
13821
13822
13823
13824
13825
13826
13827
13828
13829
13830
13831
13832
13833
13834
13835
13836
13837
13838
13840
13841
13842
13844
13845
13848
13849
13850
13852
13853
13854
13855
13856
13857
13858
13859
13861
13863
13865
13866
13867
13868
13869
13871
13872
13873
13874
13875
13876
13877
13878
13879
13880
13882
13883
13884
13885
13887
13888
13889
13890
13891
13893
13896
13897
13898
13899
13900
13901
13903
13904
13905
13906
13907
13908
13910
13911
13912
13913
13914
13915
13916
13917
13918
13919
13920
13921
13922
13923
13924
13925
13926
13927
13928
13930
13934
13936
13937
13938
13939
13940
13941
13942
13943
13944
13945
13946
13947
13948
13949
13950
13951
13952
13953
13954
13955
13956
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

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

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