Forum Discussion

CajunVeteran's avatar
CajunVeteran
Copper Contributor
Jan 18, 2023

Multiple IF Formulas with VLOOKUP

I have an excel sheet with 2 tabs to look up training for a date a course was completed. First Tab has the information that needs to be displayed. That has a Table called "OxyTraining". Second Tab ...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Jan 18, 2023

CajunVeteran 

*Edit - formula updated

 

=IF(ISNUMBER(MATCH([@1075],EmpTraining[Course ID & Emp ID],0)),VLOOKUP([@1075],EmpTraining,7,0),IF(ISNUMBER(MATCH([@616],EmpTraining[Course ID & Emp ID],0)),VLOOKUP([@616],EmpTraining,7,0),""))

 

 

  • CajunVeteran's avatar
    CajunVeteran
    Copper Contributor
    Jan 18, 2023
    Patrick2788 When i put that code, the values are blank. How would i share the file?
    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Jan 18, 2023
      If you don't have the option to attach it here, you could PM me and attach it in that space.

Resources