the experts might need to add to this, but I know you can use vlookup in this
scenario, it goes something like this:

=vlookup,A1+B5+C8,value of destination cell,0,1)

so just use the + sign to look for multiple values.

Sorry for lack of detail, I can do it better than I can explain it.

"DP7" wrote:

I want to look up multiple values, to return only one value. So far I have
only seen that I can use one lookup value in VLOOKUP. Is there any way or any
other function I should use to look up multiple values to return only one
value? The multiple lookup values I want to use are not all in the same row.
The value to be returned is in the rightmost column.