Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find match from 1st 3 columns and return the row number
I need help writing a function that would find a match in the first 3 columns
in a sheet. Then return the row number where the combination was found. Then return the row number of the next non blank row it finds. Here is an example: Row1 ColA ColB ColC Row2 DDD EEE FFF Row3 Row4 HHH I would need to search for the row that contains DDD in ColA, if match then look for EEE in ColB, and if match then look for FFF in ColC. Once found then return the row number where found, in this case 2. Then find the next value in ColA that is non blank and return this row number, in this case 4. I really appreciate your help with this. God bless you all for all the help you provide! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return proper match from three columns | Excel Worksheet Functions | |||
Match 2 Columns, Return 3rd, Differing Match Types | Excel Worksheet Functions | |||
Match Columns and return value | Excel Programming | |||
match 2 columns and return value of another | Excel Worksheet Functions | |||
Find closest match and return next highest number in range | Excel Discussion (Misc queries) |