Getting error in write cell for vlookup

Help Something Else
1

Write Cell: The write operation failed, because one of the following reasons:
► The data you want to write "=IF(ISNA(VLOOKUP($M2, MASTER!$B:$D, 3, 0)), “, VLOOKUP($M2, MASTER!$B:$D, 3, 0))” has a wrong format;
► Excel is busy;
► If your data is a formula, make sure you use comma as parameters separator;
► During the write operation make sure no dialog windows are opened.

2

Hi @sathish_Kumar6

Please try this

“=IF(ISNA(VLOOKUP($M2, MASTER!$B:$D, 3, 0)), “”, VLOOKUP($M2, MASTER!$B:$D, 3, 0))”

1 Like
3

HI @sathish_Kumar6

Try this:

 "=IF(ISNA(VLOOKUP($M2, MASTER!$B:$D, 3, 0)), """", VLOOKUP($M2, MASTER!$B:$D, 3, 0))"

Hope it works!!

1 Like
4

Thanks parvathy it worked

5

Thanks for your response irtetala

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.