Check Values

[excelkeechak]

how do i check values in base table with usertable.I need to return the BOOLEAN VALUES True or False by comparing the values in base table with usertable.

[etaf]

you are checking for both columns are you also checking which Row

results
G2 = False
as
Usertable Pencils 5
Base table Pencils 3

if you concatenate the values

so B1&A1 = D1&E1
the use Vlookup to find if the value exists

Or is it Row dependant as you seem only to be comparing the ROW

[excelkeechak]

i want to check the both values like 1 in col A and books in col b with pencils in col D and 5 in col e.the result should be TRUE if both the values are correct.same way for other items in the other rows.
Comparing 2 values in the base table with the 2 values in the user table simultaneously and printing TRUE or False in the Col G1

[excelkeechak]

Your solution is not working my dear friend any other try.....

[etaf]

No - you need to concatenate the Base table - so may solution is no good on this

I would concatenate the tables and then use lookup - but I'm sure theres a much easier way without that extra step - I'll have a think

[DonkeyOte]

Based on your file, couldn't you just use:

G2: =$A2=SUMIF($D:$D,$B2,$E:$E)
copied down