same item in vlookup

  • Thread starter Thread starter ZAIN
  • Start date Start date
Z

ZAIN

hey

anyone can help me....??

I have problem with formula vlookup

this is mydata

sheet1 sheet2
A B A B
AAA2 TC AAA2 TC
AAA1 TA AAA1 TA
AAA3 TD AAA2 TB
AAA3 TL AAA3 TD
AAA3 AR AAA3 TL
AAA2 AT AAA3 AR
AAA4 TC AAA2 AT
AAA4 TC
AAA6 AN

sheet3
A B
AAA2 TC ==>VLOOKUP($A$1:$A$10,SHEET1 $B$1:$B$10,2)
AAA1 TA
AAA2 #N/A
AAA3 TD
AAA3 TD the result should be TL
AAA3 TD the result should be AR
AAA2 AT
AAA4 TC
AAA6 $N/A

but in column C the formula it's work
 
Hi
I'm quite sure this isn't the exact VLOOKUP formula from your
worksheet. This formula would create an error:
- missing '!' in your sheet reference
- the lookup range consists only of one column (B) but you're trying to
get the second column

You may change the formula to
VLOOKUP(A1,'SHEET1'!$A$1:$B$10,2,0)
and copy down
 
Hey..frank..

Sorry I wrong with the column and missing '!'
Actualy I already use the formula same with you...but the result stil
same

Why..???


*sorry my english language not goo
 
Hi
try posting both formulas to this NG (the working from column C and the
non working)
 
hei...

sorry frank...if I use formula in column C the result still same like
column B...and to get data in column C I only copy from sheet 2 ( only
column C)


thank's
 
Hi
two ways o solve this :-)
- post your formulas to this NG which you currently use in both columns
- or if you like email me your sheet
(frank[dot]kabel[at]freenet[dot]de)

Because without further information it's quite hard to tell what your
problem is
 
Back
Top