Lookup

[leewad]

Hi

I have the following formula

=LOOKUP(B15,{"T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12"},{1158,2428,2670,2670,1513,1737,1265,1282,1174,1239,1282,2001})

all works ok until you enter T10 and over? it gives the value of T1 not what T10 should be ( 1239 ) etc

Anyone know why this is doing this and what i can do to make it work correctly.

[TMS]

The lookup array needs to be in ascending sequence, and its matches sequenced appropriately.

You need to put them in the sequence T1, T10, T11, T12, T2, ...


Regards, TMS

[dogberry]

Hi

You may not have set up vlookup for exact match, consequently it will return a close match which would be T1 instead of T10. If you end your formula with "false" it does not need to be sorted.


Chris

[leewad]

Many thanks for the reply guys ascending sequence worked ok

[TMS]

You're welcome.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save