I have a master stock list of which i would like to pull across the details of biscuits coming from the UK into another sheet. There is a column with the location code and I am looking to pull across the entire row of information on every biscuit from that country.
At the moment I am putting the following formula into the cell:
=VLOOKUP("location code",'[global biscuit list file name]Global List'!$B$2:$AZ$1023,2,FALSE)
column 2 is the biscuit name, which is the first piece of info I'd like to pull across.
Any help would be greatly appreciated.
Cheers
Bookmarks