I am trying to lookup 2 values in the same column A and get the sum of these
2 lookup values, which are also in the same column (say column B for
arguements sake)

"Mike H" wrote:

Hi,

It can be done with Vlookup in some circumstances but more often is done
with Index match. What are you trying to do?

Mike

"dannyboy8" wrote:

Is there a way to write a vlookup using multiple lookup_values in 1 formula?