Complicated Function Needed please help

[kazuki]

Hello, Im new to this forum and have come because I could not find an answer elsewhere so I figured I'll give this place a try~. The question is simply what function do I need to be able to accomplish this:

(Information I have a database with a few sheets. The main sheet is a database of items, the sheet has many columns but to name a few: Ingredient, Price Per Unit, Price Per Kg, Price Per L.

On another sheet I have the Recipe (this is why I am not being very specific, I have to make sure the recipe's are not compromised).
Each recipe has many ingredients but they do not follow the order of the column in the database sheet.

Basically what I need is a function so that the Ingredient, Price Per Unit/Kg/L goes from the Database, to the Recipe sheet based on what Ingredient is input to the Recipe (Probably an INDEX + MATCH Function ((which I already tried)) only, instead of a MATCH I need something that would be like COPY (which doesn't exist) to Copy the value from the Price Per Unit or Kg, or L based on what the Ingredient is~

Its pretty complicated but I'm sure there are people who have done something like this or simply have more brains than I do.

Thanks for taking the time and helping beforehand~

 

[Sreekanth]

Hello, Im new to this forum and have come because I could not find an answer elsewhere so I figured I'll give this place a try~. The question is simply what function do I need to be able to accomplish this:

(Information I have a database with a few sheets. The main sheet is a database of items, the sheet has many columns but to name a few: Ingredient, Price Per Unit, Price Per Kg, Price Per L.

On another sheet I have the Recipe (this is why I am not being very specific, I have to make sure the recipe's are not compromised).
Each recipe has many ingredients but they do not follow the order of the column in the database sheet.

Basically what I need is a function so that the Ingredient, Price Per Unit/Kg/L goes from the Database, to the Recipe sheet based on what Ingredient is input to the Recipe (Probably an INDEX + MATCH Function ((which I already tried)) only, instead of a MATCH I need something that would be like COPY (which doesn't exist) to Copy the value from the Price Per Unit or Kg, or L based on what the Ingredient is~

Its pretty complicated but I'm sure there are people who have done something like this or simply have more brains than I do.

Thanks for taking the time and helping beforehand~

Have you tried using VLOOKUP function, I hope this would solve your problem.

 

[Robert Mika]

Hello, Im new to this forum and have come because I could not find an answer elsewhere so I figured I'll give this place a try~. The question is simply what function do I need to be able to accomplish this:

(Information I have a database with a few sheets. The main sheet is a database of items, the sheet has many columns but to name a few: Ingredient, Price Per Unit, Price Per Kg, Price Per L.

On another sheet I have the Recipe (this is why I am not being very specific, I have to make sure the recipe's are not compromised).
Each recipe has many ingredients but they do not follow the order of the column in the database sheet.

Basically what I need is a function so that the Ingredient, Price Per Unit/Kg/L goes from the Database, to the Recipe sheet based on what Ingredient is input to the Recipe (Probably an INDEX + MATCH Function ((which I already tried)) only, instead of a MATCH I need something that would be like COPY (which doesn't exist) to Copy the value from the Price Per Unit or Kg, or L based on what the Ingredient is~

Its pretty complicated but I'm sure there are people who have done something like this or simply have more brains than I do.

Thanks for taking the time and helping beforehand~

Hello and welcome to MrExcel.
Could you post sample of your data?
Please use method in my signature.