i have three tabs (x2, invoices and adjustments). on each tab is a list of
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,TRU E)" and
"=VLOOKUP($E$4:$E$2429,adjustments!$A$7:$B$265,2,F ALSE)". 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?