Forum Discussion
La Var Blalock
Apr 21, 2020Copper Contributor
Nested VLookup Question
I am not sure if this is the right place to ask. But what i am trying to do is this. I have a spreadsheet and i want to do a vlookup and compare 2 data points like email. If it does not match i want ...
La Var Blalock
Apr 21, 2020Copper Contributor
Yeah I thought that was correct but it I am getting an error you have entered to many arguments for this function
SergeiBaklan
Apr 21, 2020Diamond Contributor
You missed second VLOOKUP in your formula, it shall be as
=IFERROR(VLOOKUP(D13,$AA$2:$AC$3500,1,FALSE),
IFERROR(VLOOKUP(F13,$AA$2:$AC$3500,3,FALSE),
"not found"))