comparison in two sheets

[geliedee]

Hello everyone..

Can you help me with the formula?
i have here a file.

In EXTRACT&PREVAL Sheet, i need a formula to compare if they have the same value in the 13.GD sheet..
and also for the same for the customer number exist column..

It should only return yes or no..

Thanks alot

[Special-K]

They won't be the same, you have text in column E on 13.GD and numbers in the EXTRACT sheet.
You should really change them to the same type.

However this solves your problem irrespective of text/numbers:

in C2 of the EXTRACT sheet
=IF(B2=VLOOKUP(A2,'13.GD Unloading & Goods Rec'!A$1:E$234,5,0)+0,"Yes","No")
and copy down column C

[geliedee]

Thank you so much!! that worked fine! Great help! thanks again!

[geliedee]

Whats the +0 means in the formula? Sorry forgot to ask

[tatoon]

The table "13.GD Unloading & Goods Rec" has the numbers formatted as text (you see the green triangle on one corner).
In "EXTRACT&PREVAL" you have them as number.

If you compare text with numbers, doesnt matter if visually the content is the same, Excel will say they are different.

If you add 0 to a text that looks like a number, then Excel converts it into a number.

You can either add 0 or multiply by 1, to convert a text to number.