ok so I am trying to automate an invoice sheet, and the trouble i have has to do with equipment. If on my equipment list Cell A is description Column B is duration, and C is charge, how do i get my cover sheet to pull column c that meets that criteria?
=LOOKUP(2,1/((INVOICE!A:A="description")*(INVOICE!B:B="charge")),INVOICE!C:C)
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
You can use the function SUMPRODUCT:
Formula:
Please Login or Register to view this content.
Neither worked.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Here you goExample.xlsx
Try this one
It's difficult to tell by your attachment how you wish the Equipment tab data to autofill into the Invoice tab, since all of the entries are unique.
Are you trying to build a form that allows someone to select these items and bill them out?
i can get that part done at a later date, i am trying to prevent hard keying errors, that seem to plague the invoices.
i just need for the rate to populate once someone puts in the equipment and duration
Hi, you have 3 rates, a daily, weekly, and monthly. How do we know which to pull?
I need to know exactly what you picture is happening.
In the Invoice worksheet, the user types the equipment type under description yes?
And then what, do quantity and duration affect rate? Are they numbers? Is rate the daily, weekly, monthly? Or is this type?
This is me guessing what you want but I have no idea. See attached.
Red
I used INDEX(...MATCH. How about this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks