Vlookup

[Jaz]

I have a excel spreadsheet with 2 sheets.

I'm trying to do a vlookup on one sheet and return a value.

The problem is, I need the vlookup to match more than 1 cell.

This is what I want to do:
On sheet 1, if cell 1 and cell 2 matches cell1 and cell 2 from sheet 2, I
want to return cell 3 from sheet 2.

Is this possible with vlookup? How should I handle this?

Thanks,
Jasper

 

[Ross Culver]

You can concatenate cell 1 and cell 2 on sheet 1 (=A1 & A2), but on sheet
two you'll have to create a single left-side column with the concatenated
results of cells 1 & 2 on that page.

Make sense?

Ross

 

[Jaz]

Works great!!

Thanks,
Jasper

You can concatenate cell 1 and cell 2 on sheet 1 (=A1 & A2), but on sheet
two you'll have to create a single left-side column with the concatenated
results of cells 1 & 2 on that page.

Make sense?

Ross