Forum Discussion
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...
Hi Meriam,
You can try this.
(for all external proposals submitted)
=IF('All Proposals'!$B2="External",HLOOKUP('External Proposals'!B$1,'All Proposals'!$B$1:$S$10,$A2,0),"")
copy the formula in all cells
(only external proposals that received funding)
=IF('All Proposals'!$B2="External",IF('All Proposals'!$C2="yes",HLOOKUP('External Funded'!B$1,'All Proposals'!$B$1:$S$10,$A2,0),""))
copy the formula in all cells
for internal
Just replace the word"External" with "Internal".
i have inserted i col A as ROW ID in all sheets for simplicity, you can go with manual row numbers in formula.