I am trying to lookup certain criteria in a spreadsheet and return a certain result. i used just a lookup formula which didn't seem to work 100%. this sheet is about 15000 line items. should i use a vlookup instead?
I am trying to lookup certain criteria in a spreadsheet and return a certain result. i used just a lookup formula which didn't seem to work 100%. this sheet is about 15000 line items. should i use a vlookup instead?
Unless your lookup range is sorted in ascending order, it is probably advisable to use Vlookup with a FALSE 4th argurment. This looks for an exact match only...
Read the Lookup and Vlookup details in Excel help for more...
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.
so i tried a vlookup and i get na as a result. here is the columns involved....lookupvalue is in column b, table array is a5:al15000, col.index # 35(AI). so this is what i entered for the formula.
=VLOOKUP(A3,'[Cable Daily Progress CWP FIXED.xls]Electrical'!$A:$AL,35,0) and it is returning #na. any idea what i have done wrong?
Is the item in A3 exactly found in column A of the other workbook?
If they are numbers you are trying to match, they both must be same format.
If they are text, look for extra spaces, mispelling, etc..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks