Excel .... cont?

Question

Look at the example below, I have columns A and B I am using =LOOKUP(J8,A3:B7) And what I expect is when I type Angelina on J8 then IV should be my result. For some reason I get V as the result... how can I get IV??
Column A: Counties
Column B: I to V

Anderson V
Angelina IV
Aransas II
Atascosa IV
Austin IV
Bee I

Answer 1

Use the formula --- =Vlookup(J8,A3:B7,2,0)

However J8 must contain the exact spelling as in column A.

Use the data -- validation -- allow list -- to create a drop down box at J8. That way you can select from the list and wont get any errors

Answer 2

try "=vlookup(J8,A:B,2,false)"
this will look at the value in J8 and look for it in all cells in column A. If it finds the match, it will return the second column, noted by 2 in the formula. "false" at the end means that it is not a range search and the value has to match exactly.

Answer 3

Excel: Lookup Function

--------------------------------------------------------------------------------

In Excel, the Lookup function returns a value from a range (one row or one column) or from an array. There are 2 different syntaxes for the Lookup function:

Syntax #1
In Syntax #1, the Lookup function searches for value in the lookup_range and returns the value in the result_range that is in the same position.

The syntax for the Lookup function is:

Lookup( value, lookup_range, result_range )

value is the value to search for in the lookup_range.

lookup_range is a single row or single column of data that is sorted in ascending order. The Lookup function searches for value in this range.

result_range is a single row or single column of data that is the same size as the lookup_range. The Lookup function searches for the value in the lookup_range and returns the value from the same position in the result_range.



Note:

If the Lookup function can not find an exact match, it chooses the largest value in the lookup_range that is less than or equal to the value.

If the value is smaller than all of the values in the lookup_range, then the Lookup function will return #N/A.

If the values in the Lookup_range are not sorted in ascending order, the Lookup function will return the incorrect value.



For example:

Let's take a look at an example:



Based on the Excel spreadsheet above:

=Lookup(10251, A1:A21, B1:B21) would return "Tofu"
=Lookup(10246, A1:A21, B1:B21) would return #N/A
=Lookup(10248, B1:B21, A1:A21) would return "Queso Cabrales"



Syntax #2
In Syntax #2, the Lookup function searches for the value in the first row or column of the array and returns the corresponding value in the last row or column of the array.

The syntax for the Lookup function is:

Lookup( value, array )

value is the value to search for in the array. The values must be in ascending order.
array is an array of values that contains both the values to search for and return.



Note:

If the Lookup can not find an exact match, it chooses the largest value in the array that is less than or equal to the value.

If the value is smaller than all of the values in the array, then the Lookup function will return #N/A.

If the values in the array are not sorted in ascending order, the Lookup function will return the incorrect value.



For example:

Let's take a look at an example:

=Lookup("T", {"s","t","u","v";10,11,12,13}) would return 11
=Lookup("Tech on the Net", {"s","t","u","v";10,11,12,13}) would return 11
=Lookup("t", {"s","t","u","v";"a","b","c","d"}) would return "b"
=Lookup("r", {"s","t","u","v";"a","b","c","d"}) would return #N/A
=Lookup(2, {1,2,3,4;511,512,513,514}) would return 512

Answer 4

I am an EXCEL whiz but you have totally lost me.......sorry