Autocomplete?

snoopy0522 · May 14th, 2002, 11:04 AM

I am working with a lot of "like" fields. In fact, I am using excel for a log for aircraft flights. When it put the aircraft # into one field, how can I make it know what type of aircraft it is and put the type of aircraft into the appropriate field next to the field that the aircraft number was entered?

Brian from Maui · May 14th, 2002, 11:12 AM

Snoppy,

Try using VLOOKUP where
Column A - aircraft number
Column B - aircraft type
Name the range of columns A and B
In a cell where you want the aircraft type enter
=VLOOKUP(C1,range,2)
where C1 is where you enter the aircraft number
What airline?

Oh! and column A needs to be sorted

[ This Message was edited by: Brian from Maui on 2002-05-14 10:40 ]

invisigirl · May 14th, 2002, 11:24 AM

Brian from Maui, you are a damn genius. I was doing the same thing, using the biggest formula in the known realm, and all along, it was this simple!

You should be knighted. Or at least get a nice coffee cake.

Brian from Maui · May 14th, 2002, 11:30 AM

invisigirl,

I'm damned, but NO genius!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 11:04 AM	#1
snoopy0522 New Member Join Date: May 2002 Posts: 1	I am working with a lot of "like" fields. In fact, I am using excel for a log for aircraft flights. When it put the aircraft # into one field, how can I make it know what type of aircraft it is and put the type of aircraft into the appropriate field next to the field that the aircraft number was entered?

May 14th, 2002, 11:12 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Snoppy, Try using VLOOKUP where Column A - aircraft number Column B - aircraft type Name the range of columns A and B In a cell where you want the aircraft type enter =VLOOKUP(C1,range,2) where C1 is where you enter the aircraft number What airline? Oh! and column A needs to be sorted [ This Message was edited by: Brian from Maui on 2002-05-14 10:40 ]

May 14th, 2002, 11:24 AM	#3
invisigirl Board Regular Join Date: Mar 2002 Location: Oregon Posts: 130	Brian from Maui, you are a damn genius. I was doing the same thing, using the biggest formula in the known realm, and all along, it was this simple! You should be knighted. Or at least get a nice coffee cake.

May 14th, 2002, 11:30 AM	#4
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	invisigirl, I'm damned, but NO genius!