Glad to hear that you got it to work - thanks for feeding back,

Pete


On Jul 26, 5:42 pm, LTaylor wrote:
I got it to work I think in my real description on the program in column B
was too long. When I shortened it the formula worked perfect. Thank you for
ALL your help!!!!!!



"LTaylor" wrote:
Sorry about that I didn't finish before it was sent

I have VLOOKUP(F6,Data!$A$93:$B$101,2,FALSE) in G6
I have VLOOKUP(G6,Data!$B$93:$C$101,2,FALSE) in H6
Do I have to name what is in column C the same that is in Column B and if so
can that be done? Right now I don't have C93, C94 etc named anything so I
don't know how it is referencing back to column B.

Like I mentioned before it is the darnest thing that it work fines for the
first row 93 and anything after row 95 but nothing for 94 and 95. Could
there be something in those cell that is making this not work?
"Pete_UK" wrote:

I think the first parameter in your VLOOKUP should be $F6, not G6 and
your table should cover Data!$A$93:$C$101. If you make these changes
to the formula in G6 then you can copy it to H6 and just change the
3rd parameter to 3 so you have two almost identical formulae:

G6: VLOOKUP($F6,Data!$A$93:$C$101,2,FALSE)
H6: VLOOKUP($F6,Data!$A$93:$C$101,3,FALSE)

Hope this helps.

Pete

On Jul 26, 4:18 pm, LTaylor wrote:
The strangest thing is happening. My formula is:
VLOOKUP(G6,Data!$B$93:$C$101,2,FALSE)

Column A Column B Column C
93 At Work description 1 Products 1
94 Youth Bank description 2 Products 2
95 Mobile ATM description 3 Products 3
96 IDA description 4
Products 4

B93 is named AtWork
B94 is named YouthBank
B95 is named MobileATM
b96 is named IDA

The cells is C are not named

When I go to my form spreadsheet if I choose "At Work" from my data
validation list in column F what I want in column G comes up and in column H.
At Work is the first on the list. Then if I pick the second or third thing
on the list, Youth Bank or Mobile ATM, it only fills in Column G and I get
#VALUE in column H. But if I pick any thing on the list after the third
item, like IDA, it works again.

I have tried everything to see if I have something in the cells C94 and C95
that are making invalid.
What am I doing wrong?

"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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -