I'm not sure what you're "looking up"??
Your sample data is:
| Station Name | Mon Day | Mon Night | Tue Day | Tue Night | Wed Day | Wed
Night | Thur Day | Thur Night | Friday Day | Friday Night |
| Station 18 (Vaccum) | 276 | 363 | 231 | 146 | 54 | 175 | 172 | 180 | 208 |
238 |
| Station 12 Height Measure out of range | 69 | 116 | 85 | 107 | 48 | 60 | 52 |
59 | 96 | 74 |
and you said you're looking up:Reject counter for Zone 0, Station 18 (Vaccum)
172
Reject counter for Zone 0, Station 12 (CheckPresence) 82
but why would it return 172 and 82?I see a 172 for Thursday Day shift,but I
don't see a value for 82
As for your wildcards in your vlookup...
vlookup syntax is:VLOOKUP(lookup_value, table_array, col_index_num,
[range_lookup])
If you use Range_Lookup as "true", it will allow "approximate" matchesbut if
you use this, your list must be in "ascending" order.
so Station 12 must come before Station 18.
but.. I'm not sure at all that I understand what you're trying to accomplish.
you said you "pull these faults every 12 hours from the database into an excel
sheet"
then you "manually update these"
update what?
do you mean you READ the values from the database and update the excel sheet
manually?then what does the VLookup have to do with anything?
Could you share a file showing what you START with, the steps you do manually,
and what you want to end up with?
What is your database? msAccess? something else?
how do you read from it?Do you generate a report electronically?
I think we need more detail to help properly.
Paul-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----------------------------------------
From: Alan Walsh <alandeswa...@gmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Tuesday, December 1, 2015 10:23 AM
Subject: $$Excel-Macros$$ Excel lookup function
Hi All
problem description. I have an excel sheet that i update manually. I want to
update automatically.
Here is what I have, A list of faults in a column, across each row is the day
and night shift, Monday to Friday.
see below.
Sheet 1
|
| Station Name | Mon Day | Mon Night | Tue Day | Tue Night | Wed Day | Wed
Night | Thur Day | Thur Night | Friday Day | Friday Night |
| Station 18 (Vaccum) | 276 | 363 | 231 | 146 | 54 | 175 | 172 | 180 | 208 |
238 |
| Station 12 Height Measure out of range | 69 | 116 | 85 | 107 | 48 | 60 | 52
| 59 | 96 | 74 |
I pull these faults every 12 hours from the database into an excel sheet. i
then manually update these.
Sheet 2
|
|
|
|
|
|
|
|
|
|
|
| Reject counter for Zone 0, Station 18 (Vaccum)
172
Reject counter for Zone 0, Station 12 (CheckPresence) 82
I want to set up the lookup function in the first sheet, for each shift and
query the new data, I know this could be done in VB, but I am not that well up
on VB.
even now when i run the lookup function i set my lookup value to "*Station 18
(Vaccum)*" It did not work. the Astrix is for wild card yes? any help on this
would be deadly....
Alan
|
|
|
|
|
|
|
|
|
|
|
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
