Thread: Using IF AND and VLOOKUP
View Single Post
 
Old 11-14-2017, 06:38 AM
mandarin mandarin is offline Windows 10 Office 2016
Novice
  
Join Date: Nov 2017
Location: South Africa
Posts: 2
mandarin is on a distinguished road
Default Using IF AND and VLOOKUP
In one workbook I need to lookup where the date in a cell (E2) and the value in a cell (B3) are equal to a date and value in a 2 separate columns (date is column C and value is column A) in a different worksheet (same workbook) and return the value in the corresponding cell in column O
Attached Files
File Type: xlsx Excel Sample.xlsx (17.5 KB, 11 views)
Reply With Quote