JOY
Reputation: 389
Find a cell value on another sheet with condition
I have Sheet2 with the value of the Name list, each name has 2 values for Type A and Type B. I'd to find the value of Type A and Type B for each Name on Sheet 1. If I use VLOOKUP, I can only find 1 value of Type A. Please help.
Upvotes: 1
Views: 357
Answers (1)
player0
Reputation: 1
use in B2:
=ARRAYFORMULA(IFNA(VLOOKUP(A2:A&B1:C1, {Sheet2!A:A&Sheet2!C:C, Sheet2!B:B}, 2, 0)))
but rename Type A/B to Type 1/2
Upvotes: 1
Related Questions
- Search for one value in a row and then few other values in the same row
- get google sheet cell value based on value of other cell
- Filter by two conditions + Array Formula alternative in google sheets
- Data extract from two sheets if it meets one criteria
- How to get data from a corresponding column if cell matches data from another sheet
- Reference value from row depending on value in another cell
- Google Sheets How to Filter Column Based on Cell Reference
- get values from other cell from other sheet if match value match with other cell
- VLOOKUP inside an ARRAY to search another Google Sheets book
- Search a value from another tab/sheet in google sheets based on cell reference