Look up two criteria and return one value
Closed
officemanager
-
Apr 17, 2010 at 01:01 PM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Look up two criteria and return one value
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Forum - Excel
- How to re/name a cell if another cell contains X ✓ - Forum - Excel
- Returning Value if Criteria falls w/i range ✓ - Forum - Office Software
- Search for input criteria, return designated cells. ✓ - Forum - Excel
- Excel if cell contains date then return value ✓ - Forum - Office Software
1 reply
rizvisa1
Apr 17, 2010 at 02:01 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Apr 17, 2010 at 02:01 PM
Most easy and efficient way would be to add a working column to combine the two column in the lookup table
then you can use lookup as for example
=vlookup(A2 & B2, sheet2!A:f, 5, true)
then you can use lookup as for example
=vlookup(A2 & B2, sheet2!A:f, 5, true)