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

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