PDA

View Full Version : Solved: Vlookup table acting weird



joelle
10-26-2005, 09:38 AM
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
10-26-2005, 09:59 AM
Can you post a sample workbook?

joelle
10-26-2005, 10:01 AM
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
10-26-2005, 09:16 PM
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
10-27-2005, 08:37 AM
Hello BlueCactus,

Your formula works! Thanks a bunch.

Regards,
Nee