Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match two values
I'm trying to update a new spreadsheet and need to match two values from the
old spreadsheet. Example B1 C1 D1 ABC Insurance $100 DEF Insurance $200 ABC Taxes $300 In the new spreadsheet, the columns B and C are the same - I just need to update the number for D. How do I write a formula to match both the value in B1 and C1 and return the value in D1? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
Match Values in Rows with Partial Values in Columns | Excel Worksheet Functions | |||
How do I match values in one spreadsheet to values in another? | Excel Worksheet Functions | |||
How to match values in one column to values in another? | Excel Worksheet Functions | |||
How do I match values? | Excel Worksheet Functions |