e.g. A1 - data entry, B1 - VLOOKUP function, C1 - VLOOKUP function, where B1 and C1 look up A1.
When A1 is blank, B1 and C1 display #VALUE (or something to that effect). When A1 is blank I want them to be blank.
I put in an IF statement - IF(,(VLOOKUP(A1,'Table!A9:B20',2,0),"")
What do I put in as the first variable of the IF statement. Or are there some other ideas?
Please help!
When A1 is blank, B1 and C1 display #VALUE (or something to that effect). When A1 is blank I want them to be blank.
I put in an IF statement - IF(,(VLOOKUP(A1,'Table!A9:B20',2,0),"")
What do I put in as the first variable of the IF statement. Or are there some other ideas?
Please help!