Forum Discussion
Combining VLOOKUP and IF to pull data from an entire row
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".
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?
- Hi Meriam,
could you please share the worksheet for better understanding of what you have missed.
- i have inserted i col A as ROW ID in all sheets for simplicity, you can go with manual row numbers in formula.
