I have this formula and I am trying to copy and past it on a spread sheet for 700 rolls. =VLOOKUP($A$20,Inventory!A17:$N$5592,2,FALSE)

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
914 views
0

I have this formula and I am trying to copy and past it on a spread sheet for 700 rolls. =VLOOKUP($A$20,Inventory!A17:$N$5592,2,FALSE) This code is pulling from another sheet with 5592 rolls. each columns would change based on the location if the second sheet example =VLOOKUP($A$17,Inventory!A14:$N$5592,3,FALSE)

0

Hi. Could you elaborate on your question?

Simply the best place to learn Excel VBA