PDA

View Full Version : If statement within formula



bopo
02-29-2008, 09:16 AM
Hi

Well basically, I have several vlookups which get data from another page, depending what ID number is entered int a specific cell, below is an example of one of the vlookup statements.

=VLOOKUP(B4, DataCustomerDetails!A8:L27,2,FALSE)

Now I would like an If statement (formula), which looks at the cell B4 for the value, then looks at the sheet named DataCustomerDetails for the value, if it isnt their, a messagebox should popup saying invalid ID or something.

Hel appreciated

xld
02-29-2008, 09:21 AM
=IF(ISNA(vlookup_formula),"Invalid,"vlookup_formula)