Using Lookups to check multiple Columns
 

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.

Using Lookups to check multiple Columns
 

Try this:

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

Note how the ranges are offset.

--
Biff
Microsoft Excel MVP


"Bombay" wrote in message
...
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.