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

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

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

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