Forum Discussion
Solved
Search for data in 2 columns and return data from same row in 2 other columns
Device and OS platform: MacOS Sierra 10.12.6 Excel product name and version number: Microsoft Excel for Mac version: 15.27 Excel file attached Context: I am trying to use an IF AND function and i...
See the attached version. I created the formulas in B2 and C2, filled them down to row 4, then copied B2:C4 and pasted it to the columns to the right.
See the attached version. I created the formulas in B2 and C2, filled them down to row 4, then copied B2:C4 and pasted it to the columns to the right.
HansVogelaar of course! An index/match. Thank you so much!
