Pl. check that the result of A2&B2 which will be AABB if A2 has AA and B2 has
BB exists in the column A of Master sheet...
If you see it then just to test enter in a blank cell in Col A of Master sheet
=Sheet1!A2&Sheet1!B2 and see...You should get 0. If you get that then enter
10 in corresponding E col. You should then get 10 in the A Col...
If this works then check your values in A... they might have an extra space
or something like that...

"Kelly" wrote:

hi Sheeloo,
Thanks for the help. Unfortunately, that didn't work. I got an N/A
message. I have the following formula in G1 of table two.

=VLOOKUP(A2&B2, master!A:G, 5, FALSE)

Any ideas why???

"Sheeloo" wrote:

Sheet 1 has 1 apple jicy in Col A-C then Insert Col C and type
=A1&B1 and copy down till end of your data

If in Sheet2 Col A & B you have 1 and apple and want juicy in Col C then
type this in C1
=VLOOKUP(A1&B1, Sheet1!C:D,2,False) and copy down...

"Kelly" wrote:

Hi,
I need to match two criteria from table one and two (1, apple) and have it
pull a third piece of data from table one (juicy) into table two. You may
have multiple fruits attached to the account(1) so I need it to match both
and then give me the third.
1 apple juicy
1 banana yellow

Sorry if this is a confusing question!!
Kelly