Hello

i am trying to look up one set of data to put on another spreadsheet.

i need the formula to agree two cells (eg A21 & D1) before puting the looked
up data in. I have tried using VLookup but it only will let me select the
one lookup value.
=VLOOKUP(A21,Details!A:C,3,FALSE) & =VLOOKUP(D1,Details!B:C,3,FALSE)

i have also looked at using sum product but as the information i want to
fill in is data it just gives me a error message

thank you in advance for your help