VLOOKUP

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

I am trying to set up a lookup whereby it doesn't only
reference a single cell, but rather three cells. The
single cell isn't enough of an identifier to be useful.
Does anyone know how to do this?

Rob
 
Hi,

Without knowing what your data looks like, you might be
able to concatenate the three sets of data into one and
then perform the lookup on the one cell. For example, if
you have "A" in cell B5, "B" in cell C5, and "C" in cell
D5, you can concatenate the three values by adding this
formula to cell A5:

=B5&C5&D5

You can then perform the lookup on cell A5 and use the
OFFSET function to return the three cells.

John Mansfield
pdbook.com
 
Back
Top