Using Lookups to check multiple Columns

[Bombay]

I have used Vlookup to do simple searches, but this one is proving to be more
complex.

In Column A we have names

In Column E we have names
In Column F we have a numerical value

Column H we have names
Column I we have numerical value

I need a function that will search Column E or H, and if E or H match the
name in column A, return value F or I(respectively).

So I am guessing id probably use nested vlookups, but was having trouble
getting it to work.

 

[T. Valko]

Try this:

=SUMIF(E1:H5,A1,F1:I5)

Note how the ranges are offset.