ExcelBanter - Combination IF, VLOOKUP

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Combination IF, VLOOKUP (https://www.excelbanter.com/excel-discussion-misc-queries/228568-combination-if-vlookup.html)

glenda

Combination IF, VLOOKUP

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.

Mike H

Combination IF, VLOOKUP

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.

ND Pard

Combination IF, VLOOKUP

Use a formala similar to:

=IF(ISERROR(VLOOKUP("abc",INV Table,2,FALSE)),Q3,VLOOKUP("abc",INV
Table,2,FALSE))

Good Luck

All times are GMT +1. The time now is 12:26 AM.