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 I may suggest, please add a file (without sensitive data) and describe your plan on it. The error could be identified faster and more specifically. Please no picture, even if it is said that a picture is worth a thousand words, it is definitely not in the case of Excel.
This means that you can be helped more quickly and the best possible solution tailored to your needs can be offered. So everyone is helped.
Help to be helped.
* It's always good to add your operating system and Excel version.
Thank you for your understanding and patience.
Nikolino
I know I don't know anything (Socrates)