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