Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match and extract
Hi,
I have one worksheet, two different tab. There are two customer number columns in Sheet1. One of the two would have the customer number and the other one would be blank. Column C has an amount. Col A Col B Col C Col D (Formula to bring the amount from sheet2) 245600 50000 138956 25000 965241 14589 Sheet2 has one customer number column and an amount column. Col A Col B 245600 50000 138956 25000 965241 14589 In Sheet1, I like to bring in the amount of Sheet2 based on matching of the customer number of Sheet1 which is in two different columns. Thanks, Dinesh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP or MATCH and/or INDEX to extract value on a given date | Excel Worksheet Functions | |||
Extract or report multiple arrays if a cell match a criteria | Excel Discussion (Misc queries) | |||
Help me, compare 2 sheet and extract the match data into the new sheet. | Excel Discussion (Misc queries) | |||
Compare and match names and extract a cell content | Excel Worksheet Functions | |||
formula to extract specific data if match occurs | Excel Worksheet Functions |