Can someone fix this? =IF(A1498=”’,””),VLOOKUP,[Macros.xlsm]Color!$F$2:$J$500,4,FALSE)

[VBAProIWish]

Hello All,

I'm trying to make this cell say nothing if there is no data in column A. In other words, I don't want the cell to say "N/A" or give me an error. The formula doesn't work and I know it's because it doesn't see any data in cell A1498. I just can't seem to figure out to make this formula work.

=IF(A1498=”’,””),VLOOKUP,[Macros.xlsm]Color!$F$2:$J$500,4,FALSE)

Can someone fix this?

Thanks much!

 

[Joyner]

I think somethin like =IF(A1498="","",VLOOKUP([Macros.xlsm]Color!$F$2:$J$500,4,FALSE)) but you may be missing something in the lookup

 

[VBAProIWish]

Sorry for the delay, yes, you are correct, something is missing as it is not working. Any thoughts?

 

[Joyner]

For VLOOKUP you have four arguments, from what I see itlooks like you are missing the first argument – your lookup value (what do youwant to lookup)