Linking Multiple Cells to Single Cell

Hi Vic,

When transferring data from one location to another in a spreadsheet document you need to think in terms of 'pulling' that data 'from' a source cell, not 'pushing' the data from thee source to the destination.

To do what you describe, you'll need a formula in Table 2::B1 that searches a list to determine which row of Table 1::A it is to retrieve the correct data, and an Index column to contain the values that the formula is to search.

Here's one example, using VLOOKUP, and an added column of checkbox cells in Table 1 to use as a search range.

The formula shown below the tables is i the selected cell, B2 of Table 2.

With no cll checked in column A of Table 1, the formula will return an error message. You can prevent this by wrapping the formula in an IFERROR statement:

   current version:                VLOOKUP(TRUE,Table 1::A:B,2,close-match)+Table 1::A8

wrapped version: IFERROR(VLOOKUP(TRUE,Table 1::A:B,2,close-match)+Table 1::A8),"")

Regards,

Barry