VLOOKUP double values

[swmasson]

HI there,

Does anyone know whether it is possible to carry out a VLookup formulae
by taking two cells data from the same row and look up a value in a
differnent worksheet which has the same values in the same row?

I hope i have explained myself correctly, it's not an easyone to
explain.

Thanks for you time

Kind Regards,


SWM

 

[Arvi Laanemets]

Hi

You can use SUMPRODUCT for this. Of course when there are several rows where
both conditions are true, values in result colum are summed.

 

[Alan Beban]

HI there,

Does anyone know whether it is possible to carry out a VLookup formulae
by taking two cells data from the same row and look up a value in a
differnent worksheet which has the same values in the same row?

I hope i have explained myself correctly, it's not an easyone to
explain.

Thanks for you time

Kind Regards,


SWM

Of course it is. "On Sheet1 I have the following data in A13; and on
Sheet2 the following data in A1:3. . . ." and go on from there.

Alan Beban