Forum Discussion
Multiple Formula Errors - IF VLOOKUP and CONCATENATE
sooxan First of all, your formula contains some elements that not needed. It could be re-written like this:
=IF(ISBLANK(G10)," ",VLOOKUP(F10&G10,Lists!$C$2:$E$2,4,FALSE))But, this will also return an error. You look up the combined value of F10 and G10. VLOOKUP expects to find this value in the first column of the lookup range ($C$2:$E$2, i.e. 1 row, 3 columns) and then you want it to return the 4th column. That's impossible as there are only 3 columns in the lookup range. Hence, an error.
Perhaps your lookup range is $C$2:$E$9 with headers in the top row. Then you would need HLOOKUP and the formula could be:
=IF(ISBLANK(G10)," ",HLOOKUP(F10&G10,Lists!$C$2:$E$9,4,FALSE))
=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.
