Price lists

Not clear until you upload your sample workbook, and explain your expected results, maybe could attrack the solver around here to see your post.

cheers

Originally Posted by azumi

Not clear until you upload your sample workbook, and explain your expected results, maybe could attrack the solver around here to see your post.

cheers

What I am trying to do is have a formula that would look up a price from various different spread sheets ie cell a1 would be the manufacturer ( spread sheet name) cell b2 would be the product and this would find the right price list and would return the price of that product from that manufacturer is this possible so far i have =VLOOKUP(A9,'C:\Users\maz\Dropbox\2015 Customers\[prices abingdon.xlsx]Sheet1'!$A$3:$C$4,3,FALSE) which will only search 1 prist list but 1 have several different price list so what i am trying to do is make [prices abingdon.xlsx] go to a different price list so were it says abingdon i can refer this to a cell on a spread sheet so i can type in the name of price list to look in