LinkBack URL
About LinkBacks
good day
I having problem in doing v lookup for this. can you provide help?
attached is the excel and the pic screen shot, Thank you
return value from a list
good day
I having problem in doing v lookup for this. can you provide help?
attached is the excel and the pic screen shot, Thank you
Last edited by FDibbins; 03-30-2017 at 02:34 AM.
----
sorry AliGW: I did not read your message.
--------
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Ooops..........
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
G'day,
For starters from the attached workbook your are referencing the 'Table Array' as one row, it should be referencing columns and rows eg A1:AZ100.
Have I made you happy ??? If yes, please make me happy by pressing theAdd Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
I have closed your other thread on this question, please continue here
Also, I have renamed the thread for you, I *think* this is what you want?
Try this...
=VLOOKUP(C2,ALL!$E$2:$V$3213,11,0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Also For Vlookup, atleast one lookup value (field) mentioned in both sheet. (Account code or code)
Sheet1 Account code : ON315783 & code : 3015348795 not in "All" sheet.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
many thanks
can you teach you how to use the cursor to get this ''!$E$2:$V$3213'
eg point at which column and press shift + error down ?
I'm so sorry, I don't understand the mistake makeOriginally Posted by ratcat
many thanksI have closed your other thread on this question, please continue here
Also, I have renamed the thread for you, I *think* this is what you want?
Try this...
=VLOOKUP(C2,ALL!$E$2:$V$3213,11,0)
can you teach you how to use the cursor to get this ''!$E$2:$V$3213'
eg point at which column and press shift + error down ?
All I did was click on the 1st cell E2, then hold the shift key down and use the right-arrow to highlight across to how ever many cells across you need.
Then, while still holding down the shift key, either arrow down as far as you need, or press END and down.
To get the absoluting (the $), with the range still highlighted, press F4
thanks
after I got the result at column H2, if there is 1000 over line at the bottom, how to drag the fomula accoss,
I normally drag it down manually, after I see a ' plus sign (+)' then I drag In down ..but if lets say there is 1000 over line, wat is the best method to do it?
Hi,
when the + sign appears, just double click to copy the formula along you data.
yes, it worked ! thanks
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks