Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need formula help!
In Chart A my columns contain this: Col A Col B Col C Col D 6/2 6/9 6/16 A 1 D 3 C 3 D 4 B 2 A 2 C 4 B 3 What formula would I use to get the above information to display in Chart B? Col A Col B Col C Col D 6/2 6/9 6/16 A 1 2 B 2 3 C 3 4 D 3 4 I tried to use a 2 dimensional vlookup =VLOOKUP(A2,’Chart A'!A1:D9,MATCH(B1,’Chart A'!A1:D1,0),FALSE) The problem is that this only returns the first value. -- HBF ------------------------------------------------------------------------ HBF's Profile: http://www.excelforum.com/member.php...o&userid=34019 View this thread: http://www.excelforum.com/showthread...hreadid=552224 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |