#1
|
|||
|
|||
Lookup function does not work properly
1 Excel file, 2 tabs (attached):
1 info tab with 3 fields of which 1 is dropdown (Project), 2 other fields (Nr and Lead) are updated based on 1st. 1 tab with data (contains data for dropdown) problem; not all info of Projects in drowdown gives correct info of Nr and Lead solution? |
#2
|
||||
|
||||
Have a look at the syntax of the LOOKUP function...
Try VLOOKUP or INDEX/MATCH instead
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Combi Index/Match works best
thanks |
#4
|
||||
|
||||
You're welcome
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
left - right arrow keys don't function properly | natanzel | Word | 1 | 06-27-2017 04:38 AM |
Function SaveAs2 does not work properly | Marco Hof | Word VBA | 2 | 06-13-2016 07:39 AM |
Lookup Function Help | peterjk3 | Excel | 0 | 11-12-2014 10:48 PM |
LOOKUP and IF FUNCTION | midgetmogalle | Excel | 6 | 12-06-2013 09:35 AM |
If lookup function | samc | Excel | 3 | 03-10-2013 02:46 AM |