vlookup problem

[coltheplumb]

Hi All ok I have this =IFERROR(VLOOKUP(BA7,$BS$4:$BT$13,2),"")and it is set up like this<o></o>
BS BT<o></o>
[TABLE="class: MsoNormalTable, width: 96"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]

d*d*d*<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

420<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

d*d*d<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

400<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

d*dd<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

380<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

ddd<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

360<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

ddm<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

320<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

dmm<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

280<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

mmm<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

240<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

mmp<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

200<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

mpp<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

160<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

ppp<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

120<o></o>​

[/TD]
[/TR]
</tbody>[/TABLE]
<o></o>
The problem is when I have d*d*d* it will not show 420 butshows 400.<o></o>
Any ideas? All help appreciated Colin X<o></o>

 

[Jonmo1]

Try

=IFERROR(VLOOKUP(BA7,$BS$4:$BT$13,2,FALSE),"")

 

[coltheplumb]

please note the BS is one column and the BT is the other column

 

[VoG]

Try

=IFERROR(VLOOKUP(BA7,$BS$4:$BT$13,2,FALSE),"")

 

[coltheplumb]

WOW that was quick and it works Cheers Jonmo1

 

[Jonmo1]

Or sort the table in Ascending order by column BS