VLOOKUP double values

  • Thread starter Thread starter swmasson
  • Start date Start date
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
 
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.
 
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
 
Back
Top