Forum Home
Press F1
Thread ID: 47222	2004-07-20 00:49:00	Excel Formula	Cyberman (3746)	Press F1

Post ID	Timestamp	Content	User
253659	2004-07-20 00:49:00	For those that are guns at Excel formula - can anyone answer this questions: Having trouble getting a formula to work in excel. Why won't this formula pick up letters.It will pick up numbers OK but not letters. If the lookup of B33 is a letter it returns nothing =IF(B33="O"," ",VLOOKUP(B33,Flights,10)) If no joy, is there a magic website that will deal to this?	Cyberman (3746)
253660	2004-07-20 01:09:00	Hi Cyberman I tried your formula and it worked fine. You may (or may not) want to change the VLOOKUP function to get an exact match rather than an approximate match by changing your formula to this : =IF(B33="O"," ",VLOOKUP(B33,Flights,10,FALSE)) I named a range in the spreadsheet as "Flights", plonked ijn some data and the formula picked up numbers and characters and was not case sensitive. I think the problem will be something other than the formula. Have you checked that the range named flights includes all of the data you are trying to search? Also, you could try copying everything into a new spreadsheet and see if that works. Are the letters in the Flights range actually characters or a formula? Sometimes usinga formula in a lookup table returns funny results. Sorry for not being much help. Andrew	andrew93 (249)
253661	2004-07-20 01:26:00	There is a good excel site here (www.mrexcel.com) hth	johnboy (217)
253662	2004-07-20 04:54:00	Try changing your code: =IF(B33="O"," ",VLOOKUP(B33,Flights,10)) to =IF(clean(B33)="O"," ",VLOOKUP(B33,Flights,10))	Marlboro (4607)
1