Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How would I go about having a function return a single value from searching
several different columns and matching the proper "name" with its "county"? Here is what the spreadsheet looks like: C D | H I J K 1 County System | System County1 County2 County3 2 Mobile ? | System 1 Mobile Montco Harris 3 Bucks ? | System 2 Ford George Newman 4 George System2 | System 3 Boman Bucks Farrel 5 York ? | System 4 Rosel Duke York D2 should = System 1 D3 should = System 3 D5 should = System 4 Each System contains unique counties. What function (s) would I need to use to match the correct county to its respective system? As of now I am trying to use in cell "D2": =INDEX(H1:K5,MATCH(C2,C2:C1246,0),MATCH(H1,I2:K2,0 )) <-completely off? obviously not working... Any help would be greatly appreciated... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need Help with Index and Match or Vlookup | Excel Worksheet Functions | |||
Using 8/23/2005 with INDEX, MATCH, VLOOKUP and IF | Excel Worksheet Functions | |||
is there a way to search with vlookup to match more than 1 column | Excel Discussion (Misc queries) | |||
dynamic, double vlookup, match, index, dget?? different workbooks | Excel Worksheet Functions | |||
VLookup or Index Match ? | Excel Worksheet Functions |