VLOOKUP CROSS SHEET REFERENCE

Bobby1

MY QUESTION:

I am using a vlookup/cross sheet reference to populate when specific criteria are met, such as vendor name and contact number.

=IFERROR(IFERROR((VLOOKUP(Payee@row + [Agrmt No. 1]@row, {MATCHING ACTIVE CONTRACTS Range 6}, 6, false)), (VLOOKUP(Payee@row + [Agrmt No. 2]@row, {MATCHING ACTIVE CONTRACTS Range 6}, 6, false))), "Not Found")

SUGGESTED SOLUTION:

Make sure that your {MATCHING ACTIVE CONTRACTS Range 6} includes all the rows needed for lookup. Better option is to define the range to include entire columns, that is, the [Column 1]:[Column 6] instead of [Column 1]1:[Column 6]20

MY FOLLOW QUESTION:

What would this look like in the formula?

=IFERROR(IFERROR((VLOOKUP(Payee@row + [Agrmt No. 1]@row, {MATCHING ACTIVE CONTRACTS [Column 2]:[Column 6]}, 6, false)), (VLOOKUP(Payee@row + [Agrmt No. 2]@row, {MATCHING ACTIVE CONTRACTS [Column 2]:[Column 6]}, 6, false))), "Not Found")

Paul Newcome

When setting up your ranges, try clicking on the column headers. This will select the entire column and automatically pick up new rows as they are added to the source data.