•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need a formula to match two columns and another 2 columns to return a value
For the data I have to match up two names and two cities. If they match then they should return a value of the correct ID. The name, city, and ID that are being matched up to live in another sheet.
So, if Column A (sheet 1)= Column A(sheet 2) and Column B(sheet 1) = Column D(sheet 2) then they'll return the correct ID from column E in sheet 2.
Right now I have a formula two match the two names and return a value, but some of the names are repeats so I need a second match item to get the correct ID.
This is my current formula to match up just the names and return the ID.
=INDEX('Sheet 2'!B:B,MATCH(TRUE,EXACT(O6,'Sheet 2'!A:A),0))
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#AI formula generation techniques
#generative AI for data analysis
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#formula
#match
#columns
#ID
#names
#cities
#value
#data
#sheet
#correct