Fiesta Fan Forums - View Single Post

**Blaaaaaaaah** · 07-08-2011, 02:34 AM

I went into a new spreadsheet and took away all the table stuff so it's just raw data:

=VLOOKUP(G2,Sheet2!A1

450,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

07-08-2011, 02:34 AM	#9
Blaaaaaaaah WONDERCLERIC Tournaments Won: 15 In-Game Name: Bla~ahs Current Level: 7x Server: Teva Posts: 10,495	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 __________________ =)