How do I use 1 excel sheet to check another?

P

Pawan

I am trying to find out that if I had entered data on one sheet, and I want
to see how the data fits in to the "master sheet". Is there any way I can do
this?
 
T

Toppers

A clearer explanation is needed: what do you mean by "fits in" to the Master.

An example of the data and "fit" would help.
 
P

Pawan

Hi Toppers,

Let say I was entering a hotel booking on to an excell sheet and I wanted to
use the data to check whether a room is a valiable , which is on another
Excell sheet. Imagine I want to check if the data for the booking, and I have
entered the date on a sheet, I want an automated method of checking this data
against the master sheet, which has all the bookings.
 
T

Toppers

There is no simple answer but the likely functions you would use are:

MATCH, VLOOKUP and INDEX (including a combination of these).

To use your example:

A room has many properties:

-single/double/twin
-smoking/non-smoking
-bath only/bath plus shower
-available dates
etc

so a "lookup" for a particular room could (would!) involve matching a number
of criteria (properties) in order to find a match and hence availability. So
having entered the base criteria, perhaps a "Check Availability" button would
initiate a macro to perform the checks.

..... not necessarily a simple solution.
 
Top