google-sheets
How to combine these two tables
please do anyone have idea on how to do this with googlesheets
Table 1
| Countries | Currency |
|---|---|
| Nigeria | Ngn |
| Canada | Cad |
| USA | Usd |
Table 2
| Countries | Continent |
|---|---|
| Nigeria | Africa |
| India | Asia |
| Germany | Europe |
I want to accomplish this
| Countries | Continent | Currency |
|---|---|---|
| Nigeria | Africa | Ngn |
| India | Asia | |
| Germany | Europe | |
| Canada | Cad | |
| USA | Usd |
Any idea is welcome... Thanks
Solution
You can use:
=ARRAYFORMULA(LET(c,UNIQUE(TOCOL({D2:D;A2:A},1)),IFNA({c,VLOOKUP(c,D2:E,2,0),VLOOKUP(c,A2:B,2,0)})))
- The download /back-up of Google scripts (.gs files) bounded to Google Spreadsheets
- How can I update this formula to work for all columns continuously to the right and not just the current 2 it's set up for?
- How do I retrieve the most frequent text value in a column that has cells with multiple entries in Google sheets?
- I do not understand the error message when I try to use QUERY() function in Google Sheets
- Google spreadsheets "VLOOKUP evaluates to an out of bounds range."
- Is there a way to display an image in an HTML table directly from a Google Sheets cell?
- Google sheets formula for showing remaining time per month for descending list of weeks
- working with dates and Calendar: need community help to improve sheet's efficiency
- Google Apps Event changeType undefined in Google Sheet
- Is there a method to display just a single cell value from a Google sheet on a Google site?
- Update PDF from Sheets and Keep Share Link and Permissions
- I want to repeat a line item in a google sheets form response based on a date value for consecutive dates
- How to show image in Google Sheets Sidebar based on active cell
- Sheet button ui formatting
- How to find the length of an array in Google Sheets?
- Formula not working when parsing set a dynamic range in Google spreadsheet formula ARRAYFORMULA
- Embed Published Google Sheet in GitHub md file
- Google Sheet: How do I pass in ARRAYFORMULA into QUERY?
- Datetime comparison query
- QUERY command WHERE parameter not finding match - format error?
- Sidebar HTML form not submitting data to Google Sheet
- Calculate the number of times groupings of three zeros (0's) appear in a row
- Remove trailing ".00" from numbers in Google Sheets
- Google Sheet Sidebar Data Entry Sidebar Form Pass Value
- Is it possible to bulk replace strings in an Excel file via API?
- Split string and get last element
- How to decode cloudflare email in Google sheets
- Sorting the string combined with arrayformula()
- Access other sheet's data from inside of ARRAYFORMULA
- how to sort a string contains list of number in google sheet?