Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to look up a value in a list and return multiple corresponding
Hello ,
I have tried this trick , given by Mr. Mathur , but it not working , I am geting the value error . Can u plz post the excel file containing the formula. Link is "http://office.microsoft.com/en-us/assistance/HA012260381033.aspx#Return%20multiple%20correspond ing" Regards Utsav |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to look up a value in a list and return multiple corresponding
Hi!
Did you enter the formula as an array? Select the cell that contains the formula. Press function key F2. Now, hold down both the CTRL key and SHIFT key then hit ENTER. If done properly Excel will enclose the formula in squiggly braces { }. These braces cannot be typed in. You MUST use the CTRL,SHIFT,ENTER key combination. Biff "Utsav" wrote in message ... Hello , I have tried this trick , given by Mr. Mathur , but it not working , I am geting the value error . Can u plz post the excel file containing the formula. Link is "http://office.microsoft.com/en-us/assistance/HA012260381033.aspx#Return%20multiple%20correspond ing" Regards Utsav |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup a value in a list & return multiple corresponding values | Excel Worksheet Functions | |||
How to look up a value in list & return multiple answers | Excel Discussion (Misc queries) | |||
How to look up a value in a list and return multiple corresponding | Excel Discussion (Misc queries) | |||
How to look up a value in list & return multiple corresponding val | Excel Discussion (Misc queries) | |||
Lookup values in a list and return multiple rows of data | Excel Worksheet Functions |