VLOOKUP and IP Addresses

[meppwc]

I use VLOOKUP often, but this is the first time that I am using it with IP addresses.
I keep getting the #VALUE error.
Example
Sheet 1, A1 contains the value 10.10.10.1
Sheet 2, A1:B3 contains
10.10.10.1 and cell1
10.10.10.2 and cell2
10.10.10.3 and cell3
The formula on sheet1, cell B1 is =VLOOKUP(A1, 'Sheet2 $A$1:$B$3, FALSE, 2)
I would expect that this formula returns "cell1"

Any input greatly appreciated

 

[Fluff]

You have the final two arguments in the vlookup the wrong way round.

 

[JackDanIce]

Your arguments are in wrong order, try:

=VLOOKUP(A1,Sheet2!$A$1:$B$3,2,0)

Swap 2 with FALSE (FALSE = 0 in formula or VBA)

 

[meppwc]

omg..............i need more sleep..........ty............sorry for even posting this

 

[Fluff]

Glad we could help & thanks for the feedback

sorry for even posting this

Don't be, we've all been there