OzGrid

How to use IF and VLOOKUP formulas together

< Back to Search results

 Category: [Excel]  Demo Available 

How to use IF and VLOOKUP formulas together

 

Requirement:

 

The user is requiring the following output:

1)Trades that are reportable
2)Trades that are non Reportable
3)Any N/A’s that come in the result (which would mean we need to update the Codes in sheet2)


The formula should be based on the following:

 

  1. If col A is TRUE and Col B is X then Vlookup Col C with codes on Sheet 2 and gives the desired result AND
  2. If Col A in sheet 1 is FALSE and Col B is reportable then give me reportable

 

 

Solution:

 

=IF(AND(A2=TRUE,B2="X"),VLOOKUP(C2,Sheet2!A:B,2,0),IF(AND(A2=FALSE,B2="Reportable"),"Reportable",""))

 

Obtained from the OzGrid Help Forum.

Solution provided by AliGW.

 

See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets

 

See also:

How to maintain the VLOOKUP font format
How to insert VLOOKUP into cell with variable array
How to use VLOOKUP (example)
How to use the VLOOKUP formula

 

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.


Gallery



stars (0 Reviews)