hello, i am in the process of making a excel sheet that pulls recipes from a vlookup and will then collate the information. I have transposed the recipes so they are in rows and then am using =VLOOKUP($B$3,TABLE,ROWS(D$5:D5)+1,FALSE) to pull the row of the ingredients. I however would like to pull the quantity of these ingredients which lie in the row below using the same vlookup. can you help?
Solved by K. Y. in 28 mins