Vba vlookup

[mts0829]

Hello Everyone

I have an issue i have a spread sheet that has SKUs for products and another spread sheet that i am going to be using for updates on in stock values. My problem is i was going to use VLOOKUP to pull the value of the in stock qty but i can not do that because my SKU is not the left most column I was wonder how would i go about writing a VBA script to pull that data off from the spread sheet to the one i will be using for uploads? is there another formula i can use or is it better to use VBA? Thanks for any help

 

[Joe4]

Yes, you can use MATCH/INDEX instead of VLOOKUP.
See: https://fiveminutelessons.com/learn-microsoft-excel/how-use-index-match-instead-vlookup