Vlookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jaz - 01 Apr 2008 19:15 GMT

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

Reply to this Message

Ross Culver - 01 Apr 2008 19:51 GMT

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

>I have a excel spreadsheet with 2 sheets.
>
[quoted text clipped - 10 lines]
> Thanks,
> Jasper

Reply to this Message

Jaz - 01 Apr 2008 20:18 GMT

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
[quoted text clipped - 18 lines]
> > Thanks,
> > Jasper

Reply to this Message