| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match or lookup
Not sure how to lookup and match.
Sheet1 has following data. Inv# amount Principal Interest 20280828 411,396.52 ? 20280830 (316,035.60) ? ? Sheet2 has following data. CM# DM# Ppal Int 20280828 411,396.52 20280830 (300,000.00) (16,035.60) I would like to fill the "?" mark based on Inv# lookup/match in sheet2. Thanks. Dinesh |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
match or lookup
=VLOOKUP(A2,Sheet2!$A:$C,3,False)
-- __________________________________ HTH Bob "Dinesh" wrote in message ... Not sure how to lookup and match. Sheet1 has following data. Inv# amount Principal Interest 20280828 411,396.52 ? 20280830 (316,035.60) ? ? Sheet2 has following data. CM# DM# Ppal Int 20280828 411,396.52 20280830 (300,000.00) (16,035.60) I would like to fill the "?" mark based on Inv# lookup/match in sheet2. Thanks. Dinesh |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
match or lookup
Thanks Bob.
The Vlookup may not work bcuz Sheer2 data in row 2 (20280830) ) starts in column B (DM#). "Bob Phillips" wrote: =VLOOKUP(A2,Sheet2!$A:$C,3,False) -- __________________________________ HTH Bob "Dinesh" wrote in message ... Not sure how to lookup and match. Sheet1 has following data. Inv# amount Principal Interest 20280828 411,396.52 ? 20280830 (316,035.60) ? ? Sheet2 has following data. CM# DM# Ppal Int 20280828 411,396.52 20280830 (300,000.00) (16,035.60) I would like to fill the "?" mark based on Inv# lookup/match in sheet2. Thanks. Dinesh |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
match or lookup
Can someone help me on this?
Thanks, "Dinesh" wrote: Thanks Bob. The Vlookup may not work bcuz Sheer2 data in row 2 (20280830) ) starts in column B (DM#). "Bob Phillips" wrote: =VLOOKUP(A2,Sheet2!$A:$C,3,False) -- __________________________________ HTH Bob "Dinesh" wrote in message ... Not sure how to lookup and match. Sheet1 has following data. Inv# amount Principal Interest 20280828 411,396.52 ? 20280830 (316,035.60) ? ? Sheet2 has following data. CM# DM# Ppal Int 20280828 411,396.52 20280830 (300,000.00) (16,035.60) I would like to fill the "?" mark based on Inv# lookup/match in sheet2. Thanks. Dinesh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match or Lookup help please... | Excel Worksheet Functions | |||
| match, lookup ??? | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Lookup / Match help ??? | Excel Discussion (Misc queries) | |||
Linear Mode
