Forum Discussion
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 ...
Yeah I thought that was correct but it I am getting an error you have entered to many arguments for this function
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"))You might also be interested in the new XLOOKUP function. Here's a screen grab from a good educational site.
And here's a link to the site itself.
https://exceljet.net/excel-functions/excel-xlookup-function
mathetes Thanks i will try it out now
