Lookup Value from Table erratic

[shriil]

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

 

[Jacob Skaria]

Hi Dear

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

If this post helps click Yes

 

[Ashish Mathur]

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

 

[slah]

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.ashishmathur.com













- Show quoted text -

Yep! Got it. Thanks a ton!

Shriil

 

[Ashish Mathur]

You are welcome.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com