VLOOKUP help

Question

My brain is dead after working on spreadsheets all day the last couple days. I know this is an easy fix but my brain isn't figuring it out.

My goal is to have this VLOOKUP Look in this column ($A:$J,9) on the Contractor Data tab and if the cell has "False" in it return a blank and if the cell has "True" in it return True. Right now it's returning both FALSE and TRUE results.

=IF($F4="","",IF(VLOOKUP($F4,'Contractor Data'!$A:$J,9,FALSE)=""," ",VLOOKUP($F4,'Contractor Data'!$A:$J,9,FALSE)))

Thank you for any help

Answer 1

I figured it out. Thank you for that help.

Answer 2

The formula is telling me I have too many arguments. Maybe I should be trying to figure this out after a couple cups of coffee this morning. Any chance you can help me by showing me how the entire formula should look?

=IF($F6="","",IF(VLOOKUP($F6,'Contractor Data'!A:J,9,FALSE),"TRUE"," "),VLOOKUP($F6,'Contractor Data'!A:J,9,FALSE)))

thank you for the help I really do appreciate it a lot.

Answer 3

Hi Randy

Try the formula

=IF(VLOOKUP($F4,'Contractor Data'!$A:$J,9,FALSE),TRUE,"")

I hope this helps you and gives a solution to your problem

Do let me know if you need more help

Regards

Jeovany