Remember, you MUST register to post on the Fiesta Fan forums. It's completely free to join. Just click HERE to become a member for free!


REGISTER NOW TO REMOVE ALL ADS ON THIS FORUM!

 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
Old 07-08-2011, 02:34 AM   #12
Blaaaaaaaah
WONDERCLERIC

 
Blaaaaaaaah's Avatar
 
Tournaments Won: 15

In-Game Name: Bla~ahs
Current Level: 7x
Server: Teva
Posts: 10,495
Blaaaaaaaah has disabled reputation
I went into a new spreadsheet and took away all the table stuff so it's just raw data:

=VLOOKUP(G2,Sheet2!A1450,3,FALSE)

Still get #N/A though.

I went to show calculation steps and apparently the error occurs with G2 - locating the postcode in the first place.

waii
__________________
=)
Blaaaaaaaah is offline   Reply With Quote
 


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
My MS Excel.. Hessah M O S 4 07-20-2010 01:48 AM
MS Excel - =LOOKUP formula Hessah M O S 4 01-19-2010 11:12 AM
Excel help =[ Blaaaaaaaah M O S 14 11-06-2008 01:09 PM
Formula. Belaslav Questions and Inquiries 10 06-23-2008 06:29 PM
Guide Index Rightclaw Draft Guides 0 01-19-2008 04:27 AM


All times are GMT. The time now is 02:08 PM.
Design by Vjacheslav Trushkin, color scheme by ColorizeIt!.
Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.