please see the attached excel file.
I use 0822 page C64 as object, to look for AP-CIIT PAGE A COLUM, It does nto work, but I search that by manually , it is ok and find it sit in A344, please advise what 's reason in there
please see the attached excel file.
I use 0822 page C64 as object, to look for AP-CIIT PAGE A COLUM, It does nto work, but I search that by manually , it is ok and find it sit in A344, please advise what 's reason in there
Welcome to the forum, reedzhou.
Please read the forum rules about thread titles, and then amend yours accordingly.
Entia non sunt multiplicanda sine necessitate
Because you have lot of spaces after word in C64 field.
So in I field instead of =C64 write =SUBSTITUTE(C64;" ";"")
And in H =VLOOKUP($I63;'AP CIIIT'!$A$2:$E$383;2;FALSE)
note that in VLOOKUP can't be number 8. Must be 2 or 4, depending what you need.
now it's working. JKL works too for cells that match.
=trim(c64) would be better as its shorter!
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
yes.. But also no need for two columns C and J... can be added in same vlookup formula. (of course, some other reason may require both columns)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks