Absolutely.

Concatenate your data into one column and make sure that the resulting data
is also a cell in the left column of your look-up array (table range).

For example: IF cell B1 contains an "A" and C1 contains a "B" and D1
contains "C" and you need to lookup "ABC", then in column A1 enter the
concatenating forumla:

=B1&C1&D1

to get "ABC".

Now, assuming there is a cell with "ABC" in the left column of the lookup
range, BINGO ... your vLookUp formula will work.

Good Luck.

"dannyboy8" wrote:

Is there a way to write a vlookup using multiple lookup_values in 1 formula?