Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple value lookups | Excel Worksheet Functions | |||
sum multiple lookups? | Excel Worksheet Functions | |||
Multiple V Lookups | Excel Worksheet Functions | |||
Multiple Lookups | Excel Discussion (Misc queries) | |||
Using COUNTIF to check values in multiple columns | Excel Worksheet Functions |