Tricky formula - need help ASAP

T

thought_i_knew_excel

New member
Joined
Jun 19, 2020
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Excel 2016
I need a two step formula....if this cell contains a word, lookup this name in a chart and return an X instead of the Time in the cell.:frusty:
 

Attachments

  • Formula HELP.xlsx
    37.1 KB · Views: 9
Hi & welcome to the board.
How about
=IF(B2="Work in Office",IF(VLOOKUP(A2,'Survey Data'!A:E,2,FALSE)=0,"","X"),"")
 
You must log in or register to reply here.
Back
Top