M
Memphus01
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
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