i need to look up a reference number on a seperate sheet in excel. I then
want to add a formula like this:
IF(AZ=0,BB,AZ)
How would I put this inside a VLOOKUP Formula.
I tried this:
=VLOOKUP(b16,fast,IF(AZ=0,BB,AZ),false)
Any suggestions.

"Chip Pearson" wrote:

You can certainly combine VLOOKUP and IF. What exactly are you
trying to do?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"George" wrote in message
...
Is there any way to combine the VLOOKUP and IF Statement
formula's into one
formula or is there any other kind of formula which does
both????