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.
|