Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDEX AND MATCH?
I want to find a value based on two variables--I am unsure of the best way to
go about this,...please help on Sheet 1 I have two cells that are updated with information from another sheet A B C 1 Employee Company --------- Employee and Company are updated automatically from another page--- I would like column C to look at a table I have on another sheet and cross reference the two to return account number the table would look somthing like this: A B C D E 1 Name WIDENER WILSON WESTON REDNE 2 Joe 123456 1231345 189248 121347 3 Jim 128988 1231375 121248 121347 4 Jane 923456 123111 177848 121347 5 Jenny 123456 123875 121238 121347 6 Kim 123456 1134545 121788 121347 7 Kendrick 123456 1231345 121244 121347 8 9 So for Column C on sheet 1 I want it to index the name from A1 with the company from B1 to give me the number at that intersection on the table on sheet 2 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDEX AND MATCH?
Try this:
=VLOOKUP(A1,Sheet2!A1:E7,MATCH(B1,Sheet2!A1:E1,0), 0) -- Biff Microsoft Excel MVP "Memphus01" wrote in message ... I want to find a value based on two variables--I am unsure of the best way to go about this,...please help on Sheet 1 I have two cells that are updated with information from another sheet A B C 1 Employee Company --------- Employee and Company are updated automatically from another page--- I would like column C to look at a table I have on another sheet and cross reference the two to return account number the table would look somthing like this: A B C D E 1 Name WIDENER WILSON WESTON REDNE 2 Joe 123456 1231345 189248 121347 3 Jim 128988 1231375 121248 121347 4 Jane 923456 123111 177848 121347 5 Jenny 123456 123875 121238 121347 6 Kim 123456 1134545 121788 121347 7 Kendrick 123456 1231345 121244 121347 8 9 So for Column C on sheet 1 I want it to index the name from A1 with the company from B1 to give me the number at that intersection on the table on sheet 2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDEX AND MATCH?
Worked perfectly--thanks so much...
"T. Valko" wrote: Try this: =VLOOKUP(A1,Sheet2!A1:E7,MATCH(B1,Sheet2!A1:E1,0), 0) -- Biff Microsoft Excel MVP "Memphus01" wrote in message ... I want to find a value based on two variables--I am unsure of the best way to go about this,...please help on Sheet 1 I have two cells that are updated with information from another sheet A B C 1 Employee Company --------- Employee and Company are updated automatically from another page--- I would like column C to look at a table I have on another sheet and cross reference the two to return account number the table would look somthing like this: A B C D E 1 Name WIDENER WILSON WESTON REDNE 2 Joe 123456 1231345 189248 121347 3 Jim 128988 1231375 121248 121347 4 Jane 923456 123111 177848 121347 5 Jenny 123456 123875 121238 121347 6 Kim 123456 1134545 121788 121347 7 Kendrick 123456 1231345 121244 121347 8 9 So for Column C on sheet 1 I want it to index the name from A1 with the company from B1 to give me the number at that intersection on the table on sheet 2 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDEX AND MATCH?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Memphus01" wrote in message ... Worked perfectly--thanks so much... "T. Valko" wrote: Try this: =VLOOKUP(A1,Sheet2!A1:E7,MATCH(B1,Sheet2!A1:E1,0), 0) -- Biff Microsoft Excel MVP "Memphus01" wrote in message ... I want to find a value based on two variables--I am unsure of the best way to go about this,...please help on Sheet 1 I have two cells that are updated with information from another sheet A B C 1 Employee Company --------- Employee and Company are updated automatically from another page--- I would like column C to look at a table I have on another sheet and cross reference the two to return account number the table would look somthing like this: A B C D E 1 Name WIDENER WILSON WESTON REDNE 2 Joe 123456 1231345 189248 121347 3 Jim 128988 1231375 121248 121347 4 Jane 923456 123111 177848 121347 5 Jenny 123456 123875 121238 121347 6 Kim 123456 1134545 121788 121347 7 Kendrick 123456 1231345 121244 121347 8 9 So for Column C on sheet 1 I want it to index the name from A1 with the company from B1 to give me the number at that intersection on the table on sheet 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions | |||
Index / Match? | Excel Worksheet Functions |