dylan7thstory
New Member
- Joined
- Jul 30, 2010
- Messages
- 6
I'm trying to write a formula to fill in data from one tab into another based on two conditions. (same spreadsheet file)
If the data in C and D on the first sheet match the data in A and D (respectively) in the second sheet, I would like the data in H on the first sheet to be entered into G on the second sheet.
I was able to use a VLOOKUP to return the desired data for one or the other, but I need a formula that matches BOTH conditions.
Any pointers?
If the data in C and D on the first sheet match the data in A and D (respectively) in the second sheet, I would like the data in H on the first sheet to be entered into G on the second sheet.
I was able to use a VLOOKUP to return the desired data for one or the other, but I need a formula that matches BOTH conditions.
Any pointers?
Last edited: