Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am having trouble with a index and match function.
My data on first tab (sheet 1) has the following: A 1 f B 2 g C 3 h I want to add a fourth column that is pulled from the second tab (sheet 2). The data on the second tab A 1 f 2 $100,000 c 3 h 17 $410,000 Note the first sheet has all of the possible categories (65 different ones). The second sheet only has catagories where the count and $ are populated (35 of total possible 65). I have tried the index and match, but am having trouble because I have three variables to look up. Any thoughts? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match & Index | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |