LinkBack URL
About LinkBacks
Hi All,
im wondering if you can help.
I need to look up column 2 columns when doing a vlookup- how would this formula go?
Thanx
Lorna
Hi All,
im wondering if you can help.
I need to look up column 2 columns when doing a vlookup- how would this formula go?
Thanx
Lorna
Could you provide a clearer explanation or what you mean and, if possible, upload a sample workbook showing the desired results?
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
sorry
I need to Vlookup A2 and B2 for a number 123
if 123 is in either of these then I need to print what Cell C2 reads in cell W2,
W2 = vlookup(A2,drafted,3,0)
but I need to look in A2 and A3
Is this any clearer?
Thanx
Lorna
Still not very clear what you are asking...
you say A2 and B2, then you say A2 and A3, and what is drafted?
you would be better off posting a sample file.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Originally Posted by NBVC
Sorry - I have mistyped when saying A3 - this should be Cell A2.
Drafted is my table array which I want to look up.
My vlookups are working well but only when I want to lookup 1 column, I want to be able to do a vlookup in 2 columns?
Maybe then...something like
=IF(ISNA(Vlookup(A1,drafted,3,0)),Vlookup(A2,OFFSET(drafted,0,1,,),2,0),Vlookup(A1,drafted,3,0))
Last edited by NBVC; 10-20-2009 at 08:43 AM.
Vlookup with OR?
Its not 2 criteria, its look in dual columns for a match
I read this statement as Vlookup in one column OR the other.... not AND
if 123 is in either of these then I need to print what Cell C2 reads in cell W2
Yes - i dont need to have the both criteria - just look in dual columns for a match. correct
your explaination is what i was trying to say!! lol
Did you try suggestion in Post # 6 above?
Yes - unfortunetly this only works in some instances?
This is why we ask to see a workbook (please post one.. delete or change confidential stuff!)... we can't guess what your workbook is like or what you really need...
In what instances does/does it not work?
A.................B..........................C................D.....................E
Reference......Partner Reference....Client..........Approval Date....Wk Drafted
12173934..................................Client 1........08/09/2006........#REF!
12170142..................................Client 1........27/09/2005........#REF!
12175540..................................Client 1........15/01/2007........#REF!
12170768......12170769...............Client 1 ........29/04/2005........#REF!
12174164......12174165................Client 1........20/09/2006........#REF!
12171719...................................Client 1........20/04/2006.........#REF!
12172112......12172113................Client 1........03/05/2006.........#REF!
12176895...................................Client 1.........24/08/2007........WK 03
M00582.....................................Client 2.........5/07/2007............#REF!
TABLE ARRAY - DRAFTED
A.................B............................C...............E
Reference.... Partner Reference......Client Wk Drafted
V00409.......................................Client 3......WK 05
S00264.......................................Client 3......WK 05
R00867.......................................Client 3.......wk06
B04102.......................................Client 3.......WK 07
W00163.......................................Client 3......WK 05
M0037........................................Client 2.......WK 05
12176584......12176585..................Client 1........WK 22
12176895...................................Client 1........WK 03
The top is the table i am going to enter my formula to - the bottom is the table array which i need to look at
i want to enter my formula into table 1 - Cell E2 asking it to look up table array comparing A2/B2 of both - if it finds a match the to enter the txt from table array E2 into that above.
Last edited by Lorna B; 10-20-2009 at 10:09 AM.
Why is it so difficult to post an actual workbook?
Click Post Reply. Click the paperclip icon... Browse and Upload the file...
...making our work more difficult isn't going to get you a fast solution...
Hi
Its not that i did not want to post a work book - i did not know how
I have posted numereous times on this site and people have always been able to help
I can see my inexperience is frustrating you.
Its ok but thank you for your help so far.
Lorna
I don't mean to sound like I do not want to help. I do indeed. It is just that many of these threads ending up going around in circles because of the lack of one of the party's ability to understand/interpret the question....
Posting a workbook is worth a lot because we can see exactly what you see and can reply with a working solution usually very quickly so that there is no chasing around the problem.
.. I see, however, you have reformatted your post above and this makes it a bit easier to see what you are after....
Try:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks