Hello All,

I have a table with blank cells for Date, Time, Name, Position, etc., that I complete with a Vlookup formula without issues when a particular cell = Yes. This is not an issue.

However, one cell has a validation cell with a drop-down box with entries of 1, 2, 3, 4, and up to 100. The user will select the number that applies to a table on another sheet. This works fine if I manually post a number from 1 to 100.

What I cannot do is tell the VLookup formula not to post anything if there is no number to be posted (i.e. for that event, there is no number to be applied). This is where the validation cell will not accept a null string (i.e. "").

How do I get around this? I have 160 tables that I want to populate from a separate table. All tables will accept the input except this validation cell, where sometimes I want to post a number and other times I do not. How do I tell the IF formula to apply nothing?

Any help would be appreciated.