drettmannc
New Member
- Joined
- Mar 15, 2017
- Messages
- 10
Hi I am looking for a formula that can vlookup based on multiple criteria. I need a formula for F4 (on spreadsheet 1) that will look up the value of column F (on spreadsheet 2) if column E (on spreadsheet 2) equals "Claro" and Column A equals the site number in A4 (on spreadsheet 1) and column D is equal to .25km.
Tall order hope you guys can assist!
Spreadsheet 1:
Spreadsheet 2:
Tall order hope you guys can assist!
Spreadsheet 1:
![spreadsheet-1.jpg](/board/proxy.php?image=https%3A%2F%2Fi.postimg.cc%2Ffyy82wgH%2Fspreadsheet-1.jpg&hash=8b6ca7bcaf0bb3bf8cf33f56fee7085d)
Spreadsheet 2:
![spreadsheet-2.jpg](/board/proxy.php?image=https%3A%2F%2Fi.postimg.cc%2FHnF96bMx%2Fspreadsheet-2.jpg&hash=cb06dc18dbc8fd9c61198a4fb2837303)