How to use Index/Match instead of vlookup still using sheet references

LouSnz
LouSnz ✭✭
edited 12/09/19 in Formulas and Functions

Hello

We have started to build a large master sheet using vlookups (mostly countifs and sumifs) cross referencing our other sheets but have quickly run into the 25000 limit.

It has been suggested that by using index/match instead we can avoid this, can anyone help how this works?

some example of formula we are currently using: - how would we change this to index/match

=COUNTIFS(OR({Sheet 1 Completed Hour}, @cell&lt;7, @cell >18), OR({Sheet 1 Created Hour}, @cell&lt;7, @cell >18), {Sheet 1 New Job}, <> β€œDirect Entry", {Sheet 1 Current Month}, 1, {Sheet 1 New Job}, <>"KIOSK", {Sheet 1 Job Time}, <60, {Sheet 1 Name}, Name1)

Β 

Thanks,Β 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!