Complex formula

[Mark1ace1]

Complex formula
I have three worksheets

One contains Customer ID, Customer name (Which is auto generated b
using VLookup on 2nd worksheet corrosponding with Customer ID) an
rating such as R 18, R 15.

Second worksheet has customer ID, Customer Name etc!

Third Sheet has Customer Name,D.O.B and Age...

This is my question...In worksheet one, I want to put Data Validatio
on Customer Name (Which is entered automatically) when a particula
name is generated it checks their date of Birth in sheet 3, rating i
sheet 1 and if they are under 18 or 15 then a message appears...!!! An
ideas would be great, or is this too complex...Would a match formul
work in Data validation?? I just want it to give a message, when
customer name appears in that cell who is trying to rent a R 18 i
underage to rent that item...

Mark

PS: anyone know how to auto generate an email, when a cell reads eithe
yes or no

 

[Arvi Laanemets]

Hi

Is there some special reason why you don't have all customer information
(second and third sheets together) in one single table. Then you could
simply use VLOOKUP function to get all needed data into worksheet one.

A workaround on fly:
In worksheet two, insert a column to left of Customer ID, which will have a
replica of Customer name column [formulas like =IF(C2="";"";C2). NB! Your
original table is shifted a column to right].
In worksheet 3, insert a column to left if Customer Name column, and get
There Customer ID's from worksheet 2, using VLOOKUP.
Now you can get needed values into worksheet 1 from worksheet 3, using
VLOOKUP.