Forum Discussion
Multiple Formula Errors - IF VLOOKUP and CONCATENATE
=IF(ISBLANK(G10)," ",(VLOOKUP(CONCATENATE(F10&G10),(Lists!$C$2:$E$2),4,FALSE))) - located in H10 The formula above is what I am using to auto-populate responses for a risk register. F10 - has...
=IF(AND(ISBLANK(F10),ISBLANK(G10)),"",VLOOKUP(F10&G10,Lists!$A$10:$B$45,2,0))
The above formula is working!! Success.
BUT
Now I need to get the column next to it to autofill a number based on the result of the above formula.
(note - the issues was my lists, as well as the formula)
sooxan glad you worked it out!
In your follow-up question you say:
"Now I need to get the column next to it to autofill a number based on the result of the above formula."
That's a bit vague. Can you explain what the VLOOKUP formula results in and what rules apply to come the "a number". Best to upload your workbook, freed from confidential information, indicating what should go where on what basis.