Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the Row # from the result of Vlookup formula
Please help i would like to know the certain row number when using Vlookup
formula. Usually the Vlookup result the contents of we are looking for, but for this case, i would like to know the row from that contents. Thank you for your help. TIA |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the Row # from the result of Vlookup formula
use MATCH
remember MATCH only handle 1 column "Andri" skrev: Please help i would like to know the certain row number when using Vlookup formula. Usually the Vlookup result the contents of we are looking for, but for this case, i would like to know the row from that contents. Thank you for your help. TIA |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the Row # from the result of Vlookup formula
Thank you for the help.
"excelent" wrote: use MATCH remember MATCH only handle 1 column "Andri" skrev: Please help i would like to know the certain row number when using Vlookup formula. Usually the Vlookup result the contents of we are looking for, but for this case, i would like to know the row from that contents. Thank you for your help. TIA |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the Row # from the result of Vlookup formula
But how to MATCH two colums (compare two databases).
MATCH the Student Name & DOB, show me the ROW. TQ "excelent" wrote: use MATCH remember MATCH only handle 1 column "Andri" skrev: Please help i would like to know the certain row number when using Vlookup formula. Usually the Vlookup result the contents of we are looking for, but for this case, i would like to know the row from that contents. Thank you for your help. TIA |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the Row # from the result of Vlookup formula
ok an eksamble :
say u have student name in A1:A100 and DOB in B1:B100 then put in C1 the student name and DOB in C2 C3=SUMPRODUCT((A1:A100=C1)*(B1:B100=C2),ROW(1:100) ) "Andri" skrev: But how to MATCH two colums (compare two databases). MATCH the Student Name & DOB, show me the ROW. TQ "excelent" wrote: use MATCH remember MATCH only handle 1 column "Andri" skrev: Please help i would like to know the certain row number when using Vlookup formula. Usually the Vlookup result the contents of we are looking for, but for this case, i would like to know the row from that contents. Thank you for your help. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting a Result in vlookup dependent on another formula | Excel Worksheet Functions | |||
Use formula result in vlookup | Excel Discussion (Misc queries) | |||
Why do I get #NA as my result when I write a vlookup formula? | Excel Worksheet Functions | |||
VLOOKUP FORMULA IS DISPLAYED AS THE RESULT | Excel Discussion (Misc queries) | |||
VLOOKUP result is not showing up - only the formula | Excel Worksheet Functions |