Lookup

[leonemc]

I am trying to do a similar function to a vlookup but the data is not a value. For example, i am looking for a ID of a customer that is all letters and want to return column 5, can someone assist w/ that function i should be using?

 

[philwojo]

You can use vlookup for that also. Are you getting an error of some kind, what is your current formula?

 

[leonemc]

This is the formula i am using ... =VLOOKUP(A111,'Active brokers with Listings'!B2:X523,2,FALSE) and i get #N/A but I know the cell A111 is inside of that range.

 

[Marcílio_Lobão]

leonemc, Good evening.

I missing something?

Why not possible use VLOOKUP function?

Scenario:

Table --> A2:F100

First column is Customer ID

H1 --> Data to be searched --> eg. ABCDEFGH

H3 --> FORMULA --> =VLOOKUP(H1, A2:F100, 5, FALSE)

Is that what you want?

I hope it helps.

 

[philwojo]

Well that won't return the 5th column it will return the 2nd, change the 2 to a 5.

As for it giving you the #N/A, that means it isn't finding an exact match. So the data you have in A111 doesn't "exactly" match anything in B2:B523.

What specific cell do you think A111 shows up in from B2:b523?

 

[leonemc]

I guess my assumption is that since (in your example) H1 and A2 are text not values it is not returning anything. For example, if i changed column A and Column H to 555 the formula works but since they are both text columns it doesnt.

 

[philwojo]

No it can lookup text, it just hast to be 100% the same, any trailing spaces will cause it to not find it.

Give use the exact cell you think the value in A111 is in and we can do some tests on it.