Forum Discussion
pbjrex
Jan 24, 2020Copper Contributor
IF FUNCTION HELP
Hi and Help please! Here's what I'm trying to accomplish but either get a spill error or just a general problem with the formula error. I'm basically asking that from the data in column A2:A1146 if ...
Patrick2788
Jan 24, 2020Silver Contributor
With all that logic you might be best off creating a lookup table then run a VLOOKUP off of it.
pbjrex
Jan 24, 2020Copper Contributor
Patrick2788 surprisingly I do more If functions than I have VLookup. How would I initiate that? And thank you!
- Patrick2788Jan 24, 2020Silver Contributor
Sample attached. Hope this helps. Enjoy your weekend!
- pbjrexJan 24, 2020Copper ContributorThank you!