Hi all can anyone please help?
I have worksheet 1 with data that does not change…
Worksheet 1
A B
1 Fish 7
2 Sugar 4
3 Eggs 11
and worksheet 2 with a list of mixed data …
Worksheet 2
A B C D etc……… K
1 Fish ? : :
2 Sugar ? : :
3 Eggs ? : :
4 Sugar ? : :
5 Sugar ? : :
6 Sugar ? : :
7 Eggs ? : :
8 Sugar ? : :
9 Fish ? : :
10 Fish ? : :
I wish to use a function or formula that can be place in Worksheet 2 column K that will look at the list in Worksheet 2 A1:A10 and compare the items to Worksheet 1 A1:A3
When a match is found then the result will be the value that corresponds to the item in Worksheet 1
and appear in column K
Result
Worksheet 2
A B C D etc……… K
1 Fish ? : : 7
2 Sugar ? : : 4
3 Eggs ? : : 11
4 Sugar ? : : 4
5 Sugar ? : : 4
6 Sugar ? : : 4
7 Eggs ? : : 11
8 Sugar ? : : 4
9 Fish ? : : 7
10 Fish ? : : 7
Please can anyone help this newbie?
Kind Regards
Gary
Bookmarks