Look up two criteria and return one value
Closed
officemanager
-
Apr 17, 2010 at 01:01 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 17, 2010 at 02:01 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 17, 2010 at 02:01 PM
Related:
- Look up two criteria and return one value
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Excel if cell contains date then return value ✓ - Office Software Forum
- If cell contains multiple text how to add other cell value? ✓ - Excel Forum
- How to re/name a cell if another cell contains X ✓ - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Apr 17, 2010 at 02:01 PM
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)