Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlook up or index match
I am working to extract all relevant data from one worksheet to another based
on on common field in main sheet. for example main sheet check # 999999 invoice sheet with check disbursements invoice # check # 12345 999999 12346 999999 12349 999999 of course there are other invoices and other checks mixed in here as well how should this be set up, so i an extract this. thanks |
#2
|
|||
|
|||
Jerry,
Combine a vlookup with an "if " statement. However, vlookups look to the right and the info you seek (Invoice #) is listed to the left. Try moving the invoice column to the right of the check number in your spreadsheet. Use the wizzards for vlookup and IF. You can always click on the equal sign preceeding the formula bar to display the wizzard. When you embed formulas and you want to see the wizzard for just that portion of the formula, place your curser on the portion you want to open and then click on the equal sign. (i.e. curser on IF or VLOOKUP, then click) This is a great way to build/embed formulas. TIP: ALWAYS use false at the end of a vlookup to return an exact match. If you can't get it to work after playing with the wizzard, make me a small sample of your spreadsheet and email it to . I'll make it work and return it to you. Good luck! -C "jerry" wrote: I am working to extract all relevant data from one worksheet to another based on on common field in main sheet. for example main sheet check # 999999 invoice sheet with check disbursements invoice # check # 12345 999999 12346 999999 12349 999999 of course there are other invoices and other checks mixed in here as well how should this be set up, so i an extract this. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match & Index | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |