Forum Discussion
Meriam Issa
Mar 21, 2018Copper Contributor
Combining VLOOKUP and IF to pull data from an entire row
Hi,
I am working with a data set that looks at the funding sources at an organization. There are multiple sheets, and I need data from the main sheet to automatically go to certain sheets based...
Meriam Issa
Copper Contributor
Thank you for the response! I copied the formula you provided, and adjusted it in the "External Funded" spreadsheet. It returned an empty cell, though, and I'm not sure why. I extended the formula into the entire first row and nothing came up.
Here what the actual spread sheet looks like, and the formula I used. Maybe I referenced the wrong cells?
Deepak Sharma
Apr 17, 2018Copper Contributor
Hi Meriam,
could you please share the worksheet for better understanding of what you have missed.
could you please share the worksheet for better understanding of what you have missed.