Glenda,

Try

=IF(ISNA(VLOOKUP(N3,INV,2,FALSE)),Q3,VLOOKUP(N3,IN V,2,FALSE))

Mike

"Glenda" wrote:

I can't get a combination of IF and vlookup to work correctly.
I want to use vlookup to find a value within a table INV based on value in
cell N3. If the value I'm looking for is not contained in INV table I want
the cell to choose contents of cell Q3.