VLOOKUP double values

S

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
 
A

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.
 
A

Alan Beban

swmasson said:
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
Click to expand...
Of course it is. "On Sheet1 I have the following data in A1:D3; and on
Sheet2 the following data in A1::D3. . . ." and go on from there.

Alan Beban
 
Top