| function to match the value on 2 sheet | francly | 6/25/12 10:17 PM | Hi, I have question on use of the function, I have 2 sheet, on second sheet have less data, how do I use lookup function the match the Model Number field and include the price on the second sheet, thanks. First Sheet (100 items) Model Number, Product |
| Re: function to match the value on 2 sheet | anandvarma | 6/26/12 2:07 AM | Dear francly, try this formula =INDEX(Sheet1!B2:B,MATCH(A2,Sheet1!A2:A,0)) however this can be done using single arrayformula, if you can post some sample data or share your spread sheet with sample data.anand varma |
| Re: function to match the value on 2 sheet | francly | 6/26/12 11:19 PM | Thanks Anand, here is the document with sample data, please show me. https://docs.google.com/spreadsheet/ccc?key=0Atgnya6AqqYJdDRjcjh0SlZkc1pzZzNNenp5R1NPMkE |
| Re: function to match the value on 2 sheet | MarinusP | 6/27/12 12:32 AM | Hi I added an extra column to sheet1 with in cell G1, I modified your existing formula a little bit: =ARRAYFORMULA(IF(ROW(F:F)=1;"Price MP";VLOOKUP(B:B,Sheet2!B:D;3*SIGN(ROW(F:F));))) I hope this helps. Please let me know if you have questions or su |
| Re: function to match the value on 2 sheet | anandvarma | 6/27/12 12:34 AM | try this =ARRAYFORMULA(IF(ROW(F:F)=1;"Price MP";VLOOKUP(B:B,Sheet2!B:D;1*SIGN(ROW(F:F));))) anand varma |
| Re: function to match the value on 2 sheet | francly | 6/27/12 1:57 AM | Thanks for both gentleman but what is the different for both the answer? Can you provide me some simple explanation how this work. |
| Re: function to match the value on 2 sheet | MarinusP | 6/27/12 1:29 PM | Hi Please have a look at this topic, where I tried to explain this formula a bit. You can see, that a formula always can be split in separate parts, to make it easier to understand. If you need more help, please let me know about which part. |
| Re: function to match the value on 2 sheet | francly | 7/30/12 11:03 PM | Thanks |