| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to MATCH value up a column
I need to match/find the first matching cell up a column. Ideas? TIA!
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to MATCH value up a column
Hi
I don't know what you are looking for, but see: MATCH(A2,A1:F1,0) or VLOOKUP(A3,Sheet2!A:B,2,FALSE) -- Please click "yes" if this post helped you! Greatly appreciated Eva "DevourU" wrote: I need to match/find the first matching cell up a column. Ideas? TIA! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to MATCH value up a column
Thankx for the reply. Here is my
formula:=IF(A11A10,C10,(IF(A11=A10,A10,"?"))). I need to have IF(A11<A10, search up column A for 1st match, example A4, display next column B4. Clear as mud? :) -JS "Eva" wrote: Hi I don't know what you are looking for, but see: MATCH(A2,A1:F1,0) or VLOOKUP(A3,Sheet2!A:B,2,FALSE) -- Please click "yes" if this post helped you! Greatly appreciated Eva "DevourU" wrote: I need to match/find the first matching cell up a column. Ideas? TIA! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to MATCH value up a column
Ignore "display next column B4". That's something else. Sorry 'bout that.
"DevourU" wrote: Thankx for the reply. Here is my formula:=IF(A11A10,C10,(IF(A11=A10,A10,"?"))). I need to have IF(A11<A10, search up column A for 1st match, example A4, display next column B4. Clear as mud? :) -JS "Eva" wrote: Hi I don't know what you are looking for, but see: MATCH(A2,A1:F1,0) or VLOOKUP(A3,Sheet2!A:B,2,FALSE) -- Please click "yes" if this post helped you! Greatly appreciated Eva "DevourU" wrote: I need to match/find the first matching cell up a column. Ideas? TIA! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
| Match using array of column and row references to match with | Excel Worksheet Functions | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| Any way for 2 column vlookups. i.e match last name then match firs | Excel Worksheet Functions | |||
| Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) | |||
Linear Mode
