Help for formula

Bird_FAT · #3 04-29-2009, 03:02 PM

First off - thanks for the swollen head Tinkertron!

OK - dehann,

I'm not sure I understand what you are looking to do!!

Are you saying that you want to enter a code number in Cell D4 from your list and have Cell E4 show the information from your result column that relates to the code number?

If so, then you need to use a VLOOKUP function

Code:

=VLOOKUP(*input cell*,*table [as range]*,*column number to find return value*)

So, using your workseet:

Code:

=VLOOKUP(D4,A3:B43,2)

This will look at Cell D4, then find the same value in the Code List, then return the value in the Result List.

ie. Code_1 = Result_1, Code_2 = Result_2, etc.

Is that what you were looking for?

Or did I guess wrong?!?!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with a formula	tinkertron	Excel	11	04-16-2009 11:43 PM
Excel Formula Help	Shahzad	Excel	1	12-07-2008 04:13 AM
formula in excell	curlymal	Excel	2	02-09-2007 11:34 AM
Mailmerge Formula	mridley	Mail Merge	0	07-27-2006 03:16 AM
Stuck on this formula!!!!	CADmanJP	Excel	2	03-10-2006 02:06 AM