Hi

I have 2 workbooks for entering Order and Bill Details. The Order
Details is as follows

OrderID Description Total
3456 rrrrr 2323424
2351 asdkljf 495890
5612 wobvwei 1265
9325 vavmewr 39224

The Bill Details workbook has the following fields

OrderID Bill no Bill Amt Description
3456 SE/3494 45351
2351 ax-erewr 23213
5612 KS/inv/034 1265
9325 345 39224
2351 bx-erewr 123033
3456 SE/3600 1125000
3456 SE/3712 572375

Now I would like to add another column after Bill Amt, to get the
matching Order Description (from Order Details) with the corresponding
OrderID in the Bill Details.I tried the VLookup formula
VLookup(A2,OrderDetails!A2:C5,2,TRUE) in the Description field of
BillDetails, but the result is erratic. The problem was solved when I
sorted the OrderDetails Table based on OrderID.

Is there any way that I can get the correct Lookup value without
sorting the OrderDetails Table.

Thanks for the help

Hi Dear

Try using MATCH with INDEX
Refer http://www.contextures.com/xlFunctions03.html

If this post helps click Yes
---------------
Jacob Skaria

Hi,

Enter the last argument of the VLOOKUP() function as FALSE (or 0) instead of
TRUE

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"shriil" wrote in message
...
Hi

I have 2 workbooks for entering Order and Bill Details. The Order
Details is as follows

OrderID Description Total
3456 rrrrr 2323424
2351 asdkljf 495890
5612 wobvwei 1265
9325 vavmewr 39224

The Bill Details workbook has the following fields

OrderID Bill no Bill Amt Description
3456 SE/3494 45351
2351 ax-erewr 23213
5612 KS/inv/034 1265
9325 345 39224
2351 bx-erewr 123033
3456 SE/3600 1125000
3456 SE/3712 572375

Now I would like to add another column after Bill Amt, to get the
matching Order Description (from Order Details) with the corresponding
OrderID in the Bill Details.I tried the VLookup formula
VLookup(A2,OrderDetails!A2:C5,2,TRUE) in the Description field of
BillDetails, but the result is erratic. The problem was solved when I
sorted the OrderDetails Table based on OrderID.

Is there any way that I can get the correct Lookup value without
sorting the OrderDetails Table.

Thanks for the help

On Mar 16, 11:37*am, "Ashish Mathur" wrote:
Hi,

Enter the last argument of the VLOOKUP() function as FALSE (or 0) instead of
TRUE

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.ashishmathur.com

"shriil" wrote in message

...



Hi

I have 2 workbooks for entering Order and Bill Details. The Order
Details is as follows

OrderID Description Total
3456 rrrrr * * * * * *2323424
2351 asdkljf * * * * * *495890
5612 wobvwei * * * * * * * *1265
9325 vavmewr * * * * * * *39224

The Bill Details workbook has the following fields

OrderID Bill no * * * Bill Amt * * * *Description
3456 SE/3494 * * * 45351
2351 ax-erewr * * * 23213
5612 KS/inv/034 * * 1265
9325 345 * * * 39224
2351 bx-erewr * * *123033
3456 SE/3600 * * 1125000
3456 SE/3712 * * *572375

Now I would like to add another column after Bill Amt, to get the
matching Order Description (from Order Details) with the corresponding
OrderID in the Bill Details.I tried the VLookup formula
VLookup(A2,OrderDetails!A2:C5,2,TRUE) in the Description field of
BillDetails, but the result is erratic. The problem was solved when I
sorted the OrderDetails Table based on OrderID.

Is there any way that I can get the correct Lookup value without
sorting the OrderDetails Table.

Thanks for the help- Hide quoted text -

- Show quoted text -

Yep! Got it. Thanks a ton!

Shriil

You are welcome.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"slah" wrote in message
...
On Mar 16, 11:37 am, "Ashish Mathur" wrote:
Hi,

Enter the last argument of the VLOOKUP() function as FALSE (or 0) instead
of
TRUE

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.ashishmathur.com

"shriil" wrote in message

...



Hi

I have 2 workbooks for entering Order and Bill Details. The Order
Details is as follows

OrderID Description Total
3456 rrrrr 2323424
2351 asdkljf 495890
5612 wobvwei 1265
9325 vavmewr 39224

The Bill Details workbook has the following fields

OrderID Bill no Bill Amt Description
3456 SE/3494 45351
2351 ax-erewr 23213
5612 KS/inv/034 1265
9325 345 39224
2351 bx-erewr 123033
3456 SE/3600 1125000
3456 SE/3712 572375

Now I would like to add another column after Bill Amt, to get the
matching Order Description (from Order Details) with the corresponding
OrderID in the Bill Details.I tried the VLookup formula
VLookup(A2,OrderDetails!A2:C5,2,TRUE) in the Description field of
BillDetails, but the result is erratic. The problem was solved when I
sorted the OrderDetails Table based on OrderID.

Is there any way that I can get the correct Lookup value without
sorting the OrderDetails Table.

Thanks for the help- Hide quoted text -

- Show quoted text -

Yep! Got it. Thanks a ton!

Shriil