Multiple VLOOKUPS in one formula?
Is it possible to create a formula that has multiple vlookups from different references?
If so, how? I've tried, unsuccessfully.
My goal is to create a formula that tracks the most recent number in a cell aug 10, sept20, oct  "blank" so the cell will show 20. We have 4 sheets that track this info on a quarterly basis (q1  aug, sept, oct), so i'd need this formula to take the most recently updated field across multiple sheet references. is this possible?
Answers

Are you able to provide some screenshots for reference?

Here you are! The first screenshot is the field in which the vlookup is in, the second shares the formula entered in that cell (adding in the below numbers), the third screenshot is the sheet in which the vlookup pulls from, the other sheets (three other) I want to pull the data from looks exactly the same. Hope this helps.

Hi @mtetzlaf
I hope you're well and safe!
Try something like this.
=SUM([HeadcountImpact]3:[HeadcountImpact]40) +" "+ VLOOKUP([RTA Code]1,{Q1 FY23  Budget Analysis Range 2}, 9,false)
Did that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

=IF(VLOOKUP([RTA Code]1, {Q4 FY23  Budget Analysis Range 1}, 9, false) <> 0, VLOOKUP([RTA Code]1, {Q4 FY23  Budget Analysis Range 1}, 9, false),
IF(VLOOKUP([RTA Code]1, {Q3 FY23  Budget Analysis Range 1}, 9, false) <> 0, (VLOOKUP([RTA Code]1, {Q3 FY23  Budget Analysis Range 1}, 9, false),
IF(VLOOKUP([RTA Code]1, {Q2 FY23  Budget Analysis Range 1}, 9, false) <> 0, (VLOOKUP([RTA Code]1, {Q2 FY23  Budget Analysis Range 1}, 9, false),
IF(VLOOKUP([RTA Code]1, {Q1 FY23  Budget Analysis Range 2}, 9, false) <>0, (VLOOKUP([RTA Code]1, {Q1 FY23  Budget Analysis Range 2}, 9, false), 0)))))
This is what I tried. My goal is to say if there is a value in the {Q1 FY23 Budget Analysis Range 2} then take that, but if there is a value in the {Q2 FY23  Budget Analysis Range 1} then take that value in place of the other. I got an "#UNPARSEABLE" error with this formula.

It looks like there may be an issue with your parenthesis.
=IF(VLOOKUP([RTA Code]1, {Q4 FY23  Budget Analysis Range 1}, 9, false) <> 0, VLOOKUP([RTA Code]1, {Q4 FY23  Budget Analysis Range 1}, 9, false), IF(VLOOKUP([RTA Code]1, {Q3 FY23  Budget Analysis Range 1}, 9, false) <> 0, VLOOKUP([RTA Code]1, {Q3 FY23  Budget Analysis Range 1}, 9, false), IF(VLOOKUP([RTA Code]1, {Q2 FY23  Budget Analysis Range 1}, 9, false) <> 0, VLOOKUP([RTA Code]1, {Q2 FY23  Budget Analysis Range 1}, 9, false), IF(VLOOKUP([RTA Code]1, {Q1 FY23  Budget Analysis Range 2}, 9, false) <>0, VLOOKUP([RTA Code]1, {Q1 FY23  Budget Analysis Range 2}, 9, false), 0)))))
You could also use a MAX like so:
=MAX(VLOOKUP(.......), VLOOKUP(.......), VLOOKUP(.......), VLOOKUP(.......))
It will probably end up being much shorter and since each is only typed out once, it should also be easier to troubleshoot.

Actually, after double checking. this only pulls the MAX number out of the four vlookups.. I am looking for the most recent number entered.. if a value is in Q1, Q2, and Q3, but not Q4 then take Q3.

I am assuming you are meaning the MAX piece?
Did you retry the nested IF with the corrected parenthesis?

Yes, still got the unparseable error..

I think even I messed up the parenthesis and put one too many on the end. Try removing one as below?
=IF(VLOOKUP([RTA Code]1, {Q4 FY23  Budget Analysis Range 1}, 9, false) <> 0, VLOOKUP([RTA Code]1, {Q4 FY23  Budget Analysis Range 1}, 9, false), IF(VLOOKUP([RTA Code]1, {Q3 FY23  Budget Analysis Range 1}, 9, false) <> 0, VLOOKUP([RTA Code]1, {Q3 FY23  Budget Analysis Range 1}, 9, false), IF(VLOOKUP([RTA Code]1, {Q2 FY23  Budget Analysis Range 1}, 9, false) <> 0, VLOOKUP([RTA Code]1, {Q2 FY23  Budget Analysis Range 1}, 9, false), IF(VLOOKUP([RTA Code]1, {Q1 FY23  Budget Analysis Range 2}, 9, false) <>0, VLOOKUP([RTA Code]1, {Q1 FY23  Budget Analysis Range 2}, 9, false), 0))))
Help Article Resources
Categories
Check out the Formula Handbook template!