A

#### aimlessmn

invoice numbers as well as an amount for payments applied to each invoice. i

need to find the corresponding amounts from the last two worksheets and list

those by the amounts on the first worksheet. i finally found a formula that

works "=VLOOKUP($E$4:$E$2429,invoices!$A$8:$B$2114,2,TRUE)" and

"=VLOOKUP($E$4:$E$2429,adjustments!$A$7:$B$265,2,FALSE)". however, it

doesn't work unless i actually type in the invoice numbers in the first

worksheet. am i missing something here or do i actually have to go in and

type in all 2,425 invoice numbers in order for the formulas to work properly?