|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 10th, 2010, 06:42 PM
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
March 10th, 2010, 07:02 PM
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
March 10th, 2010, 09:02 PM
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(A11A10, 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
March 10th, 2010, 09:09 PM
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(A11A10, 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!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
