Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching multiple columns
I hope I can explain this clearly enough. And I thank you in advance for any
suggestions or thoughts on this. I have 3 columns of data (locations are dynamic, but the column headers will always be as shown below) I want to search the first column for a specific benefit, then search the second column using those rows that had the value from the first search. I want to search the second column for a match, then search the third column (based on results from the previous matches) and find a final value in a fourth column. Example: "benefit_name" "benefit_amount_name" "benefit_amount_method" Long Term Care SSAB Long Term Disability Capital Accumulation Account CAA Salary Percent SSAB Vision Capital Accumulation Account Salary Deferral Fixed Amount SSAB Long Term Disability Capital Accumulation Account CAA Remaining Allowance Pct. I want to find the Capital Accumulation Account benefit where the benefit_amount_name = CAA and the benefit_amount_method = Remaining Allowance Pct. If I could do this in VBA, that would be slick. I want this to be unseen by the end user. I just want to grab the value I'm looking for and plop it into a cell. Is there a way to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching for multiple strings and return multiple solutions | Excel Worksheet Functions | |||
Searching rows with multiple columns criteria | Excel Worksheet Functions | |||
Searching the row that contains the same two columns | Excel Programming | |||
Searching the row that contains the same two columns | Excel Programming | |||
Tips on searching and comparing multiple columns on separate sheets. | Excel Programming |