Vlookup

  • Thread starter Thread starter Jaz
  • Start date Start date
J

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
 
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
 
Works great!!

Thanks,
Jasper

Ross Culver said:
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
Click to expand...
 
Back
Top