Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match value return a text
i need a formula in Sheet 2 of Column B to return the appropriate match
category based on value in sheet 2 column A Sheet 1 Column A a b c d e etc Sheet 2 Column A 1 1 1 2 3 4 5 i need to create column B in sheet 2 which look like the example below column A Column B 1 a 1 a 1 a 2 b 3 c 4 e 5 6 d Thanks very much for taking a look and help. ppp |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match value return a text
Hi,
Try this =INDEX(Sheet1!$C$3:$C$7,Sheet2!D4,1) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "ppp" wrote in message ... i need a formula in Sheet 2 of Column B to return the appropriate match category based on value in sheet 2 column A Sheet 1 Column A a b c d e etc Sheet 2 Column A 1 1 1 2 3 4 5 i need to create column B in sheet 2 which look like the example below column A Column B 1 a 1 a 1 a 2 b 3 c 4 e 5 6 d Thanks very much for taking a look and help. ppp |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match value return a text
Hi
I try the formula you gave me but the return text doesn't appear in the correct position. "Ashish Mathur" wrote: Hi, Try this =INDEX(Sheet1!$C$3:$C$7,Sheet2!D4,1) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "ppp" wrote in message ... i need a formula in Sheet 2 of Column B to return the appropriate match category based on value in sheet 2 column A Sheet 1 Column A a b c d e etc Sheet 2 Column A 1 1 1 2 3 4 5 i need to create column B in sheet 2 which look like the example below column A Column B 1 a 1 a 1 a 2 b 3 c 4 e 5 6 d Thanks very much for taking a look and help. ppp |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match value return a text
Try
=INDEX(Sheet1!A:A,A1,1) If this post helps click Yes --------------- Jacob Skaria "ppp" wrote: i need a formula in Sheet 2 of Column B to return the appropriate match category based on value in sheet 2 column A Sheet 1 Column A a b c d e etc Sheet 2 Column A 1 1 1 2 3 4 5 i need to create column B in sheet 2 which look like the example below column A Column B 1 a 1 a 1 a 2 b 3 c 4 e 5 6 d Thanks very much for taking a look and help. ppp |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match value return a text
Hi,
It should. I tried it and got the answer as a,a,a,b,c,d,e. Please check once again. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "ppp" wrote in message ... Hi I try the formula you gave me but the return text doesn't appear in the correct position. "Ashish Mathur" wrote: Hi, Try this =INDEX(Sheet1!$C$3:$C$7,Sheet2!D4,1) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "ppp" wrote in message ... i need a formula in Sheet 2 of Column B to return the appropriate match category based on value in sheet 2 column A Sheet 1 Column A a b c d e etc Sheet 2 Column A 1 1 1 2 3 4 5 i need to create column B in sheet 2 which look like the example below column A Column B 1 a 1 a 1 a 2 b 3 c 4 e 5 6 d Thanks very much for taking a look and help. ppp |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match value return a text
In sheet2 Cell B1
=INDEX(Sheet1!A:A,ROW()) 'to handle blank entries =IF(INDEX(Sheet1!A:A,ROW())="","",INDEX(Sheet1!A:A ,ROW())) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try =INDEX(Sheet1!A:A,A1,1) If this post helps click Yes --------------- Jacob Skaria "ppp" wrote: i need a formula in Sheet 2 of Column B to return the appropriate match category based on value in sheet 2 column A Sheet 1 Column A a b c d e etc Sheet 2 Column A 1 1 1 2 3 4 5 i need to create column B in sheet 2 which look like the example below column A Column B 1 a 1 a 1 a 2 b 3 c 4 e 5 6 d Thanks very much for taking a look and help. ppp |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match value return a text
Please ignore my second post...
"Jacob Skaria" wrote: In sheet2 Cell B1 =INDEX(Sheet1!A:A,ROW()) 'to handle blank entries =IF(INDEX(Sheet1!A:A,ROW())="","",INDEX(Sheet1!A:A ,ROW())) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try =INDEX(Sheet1!A:A,A1,1) If this post helps click Yes --------------- Jacob Skaria "ppp" wrote: i need a formula in Sheet 2 of Column B to return the appropriate match category based on value in sheet 2 column A Sheet 1 Column A a b c d e etc Sheet 2 Column A 1 1 1 2 3 4 5 i need to create column B in sheet 2 which look like the example below column A Column B 1 a 1 a 1 a 2 b 3 c 4 e 5 6 d Thanks very much for taking a look and help. ppp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Text return a value from the row | Excel Worksheet Functions | |||
Two colums match return text from another | Excel Discussion (Misc queries) | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
Match text to another worksheet and return a certain value | Excel Worksheet Functions |