So if sheet 1 detects an exact value, it will fill in a specific url into another column on the same sheet. There are about 50 unique links that would need to autofill.
Thank you for your help.
So if sheet 1 detects an exact value, it will fill in a specific url into another column on the same sheet. There are about 50 unique links that would need to autofill.
Thank you for your help.
Last edited by RW453; 08-03-2020 at 01:29 AM.
Try this, copied down...
=VLOOKUP(A3,'Product List Sheet'!$A$3:$B$5,2,0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Maybe this?
In G3 copied down:
=VLOOKUP(A3,'Product List Sheet'!$A$3:$B$5,2,0)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
is there an echo in heeeeere...in heeeere....heeeere
lol
Thank you both!!
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks