vlookup returning a value in more than one cell
My bad.
See Pete's posting about the missing brackets.
I don't understand the problem with two different results going into two
different cells.
Either enter the formulas in E2 and F2 or select E2:F2 and type Alan's formula
into E2 then hit CTRL + SHIFT + ENTER.
You need 3 columns in your lookup range in order for these to work.
Example only....................
Column A has names
Column B has cities
Column C has states
Table Array would be A1:C100
Type a name into D2 and E2 will show city and F2 will show state.
Gord
On Thu, 26 Jul 2007 06:32:06 -0700, LTaylor
wrote:
=VLOOKUP(F6,Data!$A$93:$B$101,2,FALSE)
Above is my formula for the cell and I'm trying to make it so the #NA
doesn't show up but I must not be doing your formula correctly because I keep
getting an error. Here is what I was putting:
=IF(ISNA(VLOOKUP(F6,Data!$A$93:$B$101,2,FALSE), "
",VLOOKUP(F6,Data!$A$93:$B$101,2,FALSE)
Also I'm still trying to get the other issue with more than one result going
into two different cells but I'm not having any luck yet.
"Gord Dibben" wrote:
I don't see your 2:00pm post Alan.
Downloaded headers back to this AM but still can't see it.
Google is a mess right now so didn't search there.
Gord
On Wed, 25 Jul 2007 18:06:02 -0700, LTaylor
wrote:
You are great. Thank you, thank you, thank you!!!
"Alan Beban" wrote:
Gord Dibben wrote:
You need two VLOOKUP formulas in two cells.
uh-uh.
=VLOOKUP(D2, $A$2:$C$3,2,FALSE) entered in E2
=VLOOKUP(D2, $A$2:$C$3,3,FALSE) entered in F2
You missed my post of 2:00pm? The equivalent of
=VLOOKUP(D2, $A$2:$C$3,{2,3},FALSE) array entered in E2:F2
Alan Beban
|