using vlookup in VBA

[mimi1234_9876]

Hello,

I am a novice in VBA and trying to solve a problem in excel using VBA. Any hints or suggestions would be very helpful.

I have two sheets in a workbook. One sheet (Database) has the database of products, time and costs. Cost is a function of time and product names.
Second sheet (Sheet 2) is which a user wants to calculate cost of a particular combination of product and time. The user can put 3 product names or 4 product names, so number of rows are variable in this sheet. He will also input the time for each product.

What I need is: to find the product (from sheet 2 as provided by the user) in the sheet 1(database) and replace the time with the time value provided by the user. Based on it, I need to bring back the corresponding cost to sheet 2.

The sheet 2 can have same products with different time.

I am wondering if anyone can help me on this. Any kind of hints would be helpful.

Thanks

[JOHN H. DAVIS]

Can you attach a file? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[mimi1234_9876]

Please find the attached.

[AB33]

A simple formula
B2 and drag it down

Please Login or Register  to view this content.

[mimi1234_9876]

Hello,

Thanks, but :

the Input_by_user sheet has several product "A" with different time. To calculate cost I need to loop all the different values of Time of Product A, in Database sheet and then copy the Cost from Database sheet to Input_by_User sheet.

[AB33]

You only have one product called A in sheet database (A2) and you want to return in this sheet.

[mimi1234_9876]

The Time in Database sheet will depend on the value of Time in Input_by_user sheet.
The function to calculate cost is fixed, which is here a function of time and product, as in Database sheet.

So the user can calculate cost of Product A with different time. Thats why I was thinking if you can give me any hint of how to use vlookup in loop in vba. Or any other way to do this.

Thanks

[AB33]

I do not understand.
Do you want to return the time column?
If the lookup value is column A of sheet Input_by_user and the return is column A of sheet database from column B of sheet Input_by_user.
You can add another Vlookup on column C of Input_by_user from column A of sheet database