ExcelBanter - match or lookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - match or lookup (https://www.excelbanter.com/excel-worksheet-functions/224166-match-lookup.html)

Dinesh

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

Bob Phillips[_3_]

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

Dinesh

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

Dinesh

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

All times are GMT +1. The time now is 04:13 PM.