Need Help with formula

[Mark B]

Here's what have and need to do...

Sheet1
A B C D
# of weeks RoomType $Charged Yes/No
1 Big $400
2 Medium $600
3 Big $1200
2 Small $450

Sheet2
A B
RoomType Weekly$
Small $200
Medium $300
Big $400

I need to put a formula in ColumnD in Sheet1 that will tell me if the
correct amount has been charged in Sheet 1 based upon Sheet2

THANKS!!!

 

[Fred Smith]

You want Vlookup, as in:

=if(vlookup(b2,Sheet2!A:B,2,false)*a2=c2,"yes","no")

 

[Mark B]

Awesome! Thanks!

You want Vlookup, as in:

=if(vlookup(b2,Sheet2!A:B,2,false)*a2=c2,"yes","no")