Need Help with formula
 

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!!!

Need Help with formula
 

You want Vlookup, as in:

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

--
Regards,
Fred


"Mark B" wrote in message
...
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!!!

Need Help with formula
 

Awesome! Thanks!

"Fred Smith" wrote:

You want Vlookup, as in:

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

--
Regards,
Fred


"Mark B" wrote in message
...
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!!!