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!
*IDs have been omited for privacy but there are values in the column I need to bring in the Week # values from the Master Tracker - 2026 sheet into the Week-Over-Week Modified sheet. The group and APC ID need to match. There is a potential of duplicate APC values which is why I need the group to be a criteria as well. I…
I have one sheet that is tracking PTO where a user has entered the days off. The form allows them to enter a start and end date for their PTO and enters a single record into the sheet. I have a second sheet that I am looking to pull that data into, but there is only one record per person (column in this sheet where the…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
