Solved: Vlookup table acting weird

[joelle]

Dear Experts,

I appreciate some quick help with this Vlookup table.

I have a pull-down menu on A17,
but B17, C17, D17, E17, F17 sometimes give me correct data across the table, sometimes they don't, especially when I pull M-SS7502S (from A4 above), I can never get the matching data "Japan SS7", it gives me "CCITT base" instead. Same thing happens to the other addresses on line 17, data matches on and off??

I have same formula from B:17 to F17. Did I do something wrong for the formula?

Pls see attached img and shed some light. Very appreciative.
Nee

[austenr]

Can you post a sample workbook?

[joelle]

I'd love to but I dont know how to? and I dont have a url.
What are the steps the post a workbook?
Thanks,
Nee

[BlueCactus]

Without seeing more of your data, I would guess that your problem is that you're using the approximate match syntax of VLOOKUP(). This is where the 4th argument of VLOOKUP() is set to TRUE or omitted. Approximate match requires a table in ascending order.

If possible, you might try using the exact match syntax - set the 4th argument to FALSE. e.g., =VLOOKUP($A$23, datatable, 2, False)
This syntax does not require a sorted table.

[joelle]

Hello BlueCactus,

Your formula works! Thanks a bunch.

Regards,
Nee