Sign in to join the conversation:
Hi
I'm using a report to pull together a number of different sheets. I'm looking to do a vlookup on the report. Is this possible? If not can I select multiple sheets in one vlookup?
Thanks
If(iserror(Vlookup(dataset1)),Vlookup(Dataset2))
you cannot run a vlookup on a report, but you can run one across sheets by using conditional logic like the above.
Thanks .. can I sumif into another work sheet ?
sumif(sheet1)+sumif(sheet2)
Thank you, I got this working
@L@123 is there a limit to the number of sheets you are reference for a vlookup? I am getting #incorrect argument
=IF(ISERROR(VLOOKUP([BE GEO ID]1, {FY21 Radius Partners Tech Data US MRP Range 1}, 9, false)), VLOOKUP([BE GEO ID]1, {FY21 Radius Partner Coverage Ingram Micro Range 2}, 8, false), VLOOKUP([BE GEO ID]1, {FY21 Radius Partners Synnex Comstor MRP Range 1}, 9, false), VLOOKUP([BE GEO ID]1, {FY21 Radius Partner Coverage ScanSource MR Range 1}, 9, false))
Hi @Daniel Sullivan
Not as far as I know. The only limit is the 4000 character limit in a cell.
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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
@Daniel Sullivan,
I'm having the same problem too. Did you find a way to solve it? Thanks!
Hello, I deal with a lot of batch/lot numbers that are automatically generated and start with leading zeros (e.g. 000012345). I'm trying to create a column simply to count the instances of a lot number within the column in order to quickly identify duplicates. The formula I have is =COUNTIF([Lot Number]:[Lot Number],[Lot…
I have a formula in a Smartsheet that will show the last step date completed in one column and then another formula that will show the next step to be completed. The issue I have run into is that if 2 steps are completed the same day, SS is only picking up on the first one and showing the 2nd one as the next step to be…
Hi all - i am building a monthly dashboard with separate columns for each month's status, key takeaways, and next steps. I am wanting to build an automation that says for example: 'your {{current month}} status update is due, your last {{last month}} update was {{status color}}. Please be sure to indicate your key…
