Imtiaz
Reputation: 153
Google Sheet calculation based on matching cells
How can I compare between A and E and If matches then put the difference in I?
Upvotes: 1
Views: 35
Answers (1)
player0
Reputation: 1
=ARRAYFORMULA(IF(LEN(I4:I),
IFERROR(VLOOKUP(I4:I, E4:F, 2, 0))-
IFERROR(VLOOKUP(I4:I, A4:B, 2, 0)), ))
Upvotes: 1
Related Questions
- Find and repeat a cell value if values match
- If statement from different sheet base on two cell
- Looking up a value based on 2 conditions with HLOOKUP
- get values from other cell from other sheet if match value match with other cell
- Vlookup formula in Google Sheet
- Vlookup where 2 columns match values
- How To Do Vlookup With Conditional
- Using VLOOKUP in an array formula on Google Spreadsheets
- Excel Cell value based on VLookup
- Google Spreadsheet vlookup with arrayformula PLUS multiplication of returned value(s)